Custom aggregator:
I'm looking for a method of implementing a custom measure based on basic calculation using 2 other existing measures. The main goal is to prevent the XamPivotGrid from doing any kind of aggregation.
I think this is common situation related with Gross Profit percent (GP %) calculation defined as
GP %= (SALES-COST)/SALES
where SALES and COST are existing measures.
In this case the GP % ca not be aggregated (sum or average) and must remain with the same expression regardless whether the dimensions are expanded or not.
The snapshot below shows the desired result
Any suggestion (preferably in VB.Net) would be greatly appreciated.
Fabian Zandomeni
Hi Fabian,
I'm working on the details of your question.
Hello,
Look at the snapshot below and let me know if that's the result you expect
Regards.Plamen.
You got it!
That’s exactly what I’m trying to accomplish.
How do I do it?
Fabian.
Look at the attached files. In MainPage.cs is implemented the method that sets up the FlatDataSource.
Hello Plamen
would it be possible to create an aggregator based on dimensions data?
(such as - number of expanded columns, or the position of the current item)
thank you
maya
Thanks a lot Plamen. It is working exactly how I needed it.
Cheers,