Skip to Content
0
Former Member
Jun 06, 2008 at 08:43 AM

No Key Figure aggregation in query

27 Views

Hi experts,

I've a cube with material data, with the following fields (Key Figures in bold)

Country Plant Material StockType StockCategory | Quantity Price(Unit)

-


|----


MX 2016 10020 A X | 5 50

MX 2016 10020 B Y | 3 50

MX 2016 10020 A Y | 10 50

MX 2016 10020 B X | 4 50

I have registers with the same Country, Plant and Material, but with different Stock Type and Stock Category. I want a query to show qhte quantity by Country/Plant/Material, without the StockType and Stock Category.

So the query must show the following:

Country Plant Material | Quantity Price(Unit)

-


|----


MX 2016 10020 | 22 50

My problem is that the Key Figure Price (unit) is aggregated and shows 200 instead 50. The Key Figure Quantity is Ok, it must be added.

Any ideas?

Best regards,