I've requirement to show stock value by profit center and Material . Below is report format. Value is calculated as Price multiplied by quantity
Profit Center Material Price Qty Value
A 1001 3 10 30
1002 4 20 80
1003 5 30 150
-
Total 60 260
Issue here is if I take the MAterial out from the drilldown then user would like to see the aggregated qty and value at profit center level. Since Price is at material level, it gets aggregated and I get below result
Profit center Price Qty Value
A 12 60 720
I can get desired result by adding value key figure in the cube and doing calculation at cube level. Question is, Is there a way aggregation can be handled at query level so that I get value as 260 when only profit center shown in the rows.
Thanks
Milind