When using xamPivotGrid with a FlatData source, is it possible to customize the aggregation function to be used?
For example we need an employee efficiency data to be shown in xamPivotGrid, with three Measures:
'Productive Hours' (int value), 'Total Hours' (int value) and '% Efficiency' (decimal %).
where '% Efficiency' = 'Productive Hours' * 100 / 'Total Hours'.
By default the '% Efficiency' measure is also just adding up all the individual percentages, rather than applying the same formula on the aggregates.
Is there a way to change this behavior? I can not find any documentation for the same.
Hi,
we do not have this functionality in the current version of PivotGrid control. Probably in the next version it will be supported. You can expect our release in April.
Regards,
Dimitrina
Thanks Dimitrina.
We've recently purchased 3 licenses for NetAdvantage Ultimate 2010 Vol. 3 and will be buying 4 more licenses very soon. For an upcoming feature in our product, we are really hoping that this functionality will be available to us pretty soon.
Can you please chek with the related team and let me know whether this will be available in next realease or not and when is the next realease planned?
thanks,
Jatin