Hi,
Here is my query requirement:
Formula KF-> Priceperpiece05 = Sales 05(RKF)/Qty 05(RKF)
And BaseSales(Formula KF)= Priceperpiece05 * Qty 06(RKF)
Cust |Material | (Priceperpiece05) | BaseSales
1 102091 $2.72 /PC $54.40
1 102098 $1.03 /PC $12.36
Overall result $2.27/pc $66.76
This works fine with cust-material combination.If i remove the material in the query, the customer overall result shows different basesales value(due to the after aggregation).
Is there any way i can get the correct overall results without the material in the query?
regards,
ravi
Message was edited by: Ravi