Bex query calander year/month with calculated keyfigures.
Hi Bw gurus,
i created a query which takes only one calendar month to display Items and sales and average on hand values.
(Average on hand is a calculated key figure which is an average of past 12 months on hand value (on hand in month+ on hand in month-1+.........on hand in month-12)/12).
Now i created same query based on above query but I used calendar year/month interval variable instead of single variable entry. i am getting all the fields with exact values but average on hand (calculated key figure value) is showing wrong data.
Your valid solution deserves the points.