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