Dear CR Expert,

Could you please help me regarding this issue?
I would like to be able to capture the number of quantity of inventory sold by weekly ( 7 days) for 48 week. We have the cutoff on inventory from Mon to Sun

For example;
ItemID ItemDes   QtWk48 QtWk47 QtWk46 ….. QtWk2 QtWk1

Which formula should I use? Your help would be much appreciated

Thanks in advance

Update: I have been able to use cross tab ; however , I would like to let the user input the current date(parameter) and the end day is dynamic backward for 48 weeks that shows in the cross tab. Please suggest.

Edited by mickey_aw - 13 Sep 2012 at 5:08pm