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,