Skip to Content
0
Former Member
Mar 18, 2011 at 05:19 PM

BEx Query Key Figure Aggregation

776 Views

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