Question:
I have the following situation in a query:
Qty Unit price Value (=Qty*Unit price)
MatTyp1 Mat1 10 5 50
Mat2 20 3 60
Total MatTyp1 30 should be 110
If I do not drilldown by material, the query should look like:
Qty Unit price Value (=Qty*Unit price)
MatTyp1 30 should be 110
How do I define the query to be able to display the correct result in the column value in all situations?
Thanks,
I
Answer:
Calculation before aggregation is a feature that can be turned on for each query(not sure where it is exactly done). It can be used for formulas and calculated key figures. Use it when the formula can be only calculated before the data in this formula is aggregated.