But to compare Inventory, I cant sum the numbers, I have to pick up sum of inventory no of a maximum week. Say for example, If I am tracking inventory for Oct'13, I will report only last week inventory.
Now I want to compare these two things, showing MoM comparison of Invenory figures for rolling 12 months and Inventory would be subject to max week inventory.
I hope , I have able to explain this problem properly.