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.
I'm working on the details of your question.
Look at the snapshot below and let me know if that's the result you expect
You got it!
That’s exactly what I’m trying to accomplish.
How do I do it?
Look at the attached files. In MainPage.cs is implemented the method that sets up the FlatDataSource.