Need Correct Calculation for Price Keyfigures in Week,Month,Quarter and Year Level
I am using Unified Planning Area. I have a very simple requirement for Actuals Price Calculation. It should be Actuals Revenue / Actuals Qty.
Now the issue that I am facing is: While I am at week level and say for Week 1: Actuals Rev is 2000 and Actuals Qty is 200 then Actuals Price is showing 10, but as soon as I am at month level the Price at week level is just getting summed up. Can anyone please suggest how i should configure my Keyfigure such that when I am at week or month or quarter level the price value should be exactly Actuals Revenue/Actuals Quantity at that level. Please let me know if i have made my requirement clear.