Hi,
While I am doing Inventory Development, got some issues in reporting. Below is my reporting info.
Chars in rowsr: CompCode, Sector(Nav attribute to plan), Calmonth.
1. We get Closing Inventory in runtime ( 0valstockval )
2. Turnover (Just a KF)
3. Avg Inventory is a moving avg of Closing Inventory
4. Ratio = Turnover / Avg Inventory.
Problem in getting Moving avg in Sector Level. If I use moving avg option in Calculation tab, It is working till the end of the report not breaking at Sector level. If I use exception aggregation, its not working and also that will calculate only Avg not a moving avg.
So how to get avg inventory and Ratio values.
If you give me solution in workbook also ..it ll be fine ..
Thanks,
_R