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. And so after doing much research, I ran into this post and I followed the instruction to succesfully achieve the above functionality using Custom Aggregator. However this may not be a viable solution for my application since the Dynamic Measures would be based on formulas coming in from the database via WCF service. Hence I can't really create a static Custom Aggrgegator.
Also I see that you can specify AggregatorType = Calculated when defining DimensionMetadata. Can you please its usage and if there is a way to specify formula based on other Measures.
Thanks.
Hi,
That's fine. Let me know if you have any questions.
Not sure yet -- haven't had a chance to try out this solution... Will update this forum once I have.
HI,
I’m just following up on this forum post.
Do you need further assistance regarding this issue?
If so, please feel free to contact me.
Your question doesn’t appear to be an issue of the pivot grid. It’s more about implementing a functionality. The suggested is to use this free library http://flee.codeplex.com/ to accomplish what you need.
I believe that thread and sample are similar to the one that epsiwebdev mentioned.
http://news.infragistics.com/forums/t/56695.aspx
Plamen is discussing a Custom Measure Aggregator there also and provides code as well.
I think this question is whether there is an alternate way to achieve the same functionality by using formulas supplied by a database.
I haven’t heard back definitively from our development staff but will update you as soon as I do.