I have a query problem
In my Cube i have the following char / k.f
Plant, Material, Std Price, Qty.
P1, M1, 10, 50
P2, M1, 11, 10
P3, M1 12, 25
P1, M2, 27,5
P2 M2, 22,10
I have standard price as both attribute of 0mat_plant as well as k.f in the Cube.
Std Price is only valid if the query output contains Material.
I need to calculate the value_CKF = Std Price * Qty at the query level and display the result at Plant level.
The problem is if i drag material from the query output, the calculated k.f value_CKF is calculated wrong. i:e the std Price field is aggregated to the plant level and then it is doing the calculation
I would like the output as
Plant, Qty, Value_CKF in the query output.
P1, 37, xxxx