Hello Friends,
I have a BEx query in the following format:
Material Qty1 Qty2 Value
M1 1 4 4
M2 2 5 10
M3 3 6 18
Total 6 15 32
Here Value = Qty1*Qty2
The "Total" row shows the sum for all columns when the query is at material drill down level.
As soon as I remove the drill down for Material, in the overall result row, it shows 90 for "Value".
So at material drilldown it does an addition, while when we remove the drilldown it does multiplication.
I want the figure of 32, at the overall result level.
Please help me fix this.
Regads,
Bhushan