If you are going to switch from a perpetual moving average system to a
FIFO system you'll likely have to give each FIFO layer a unique id, and
make that part of your pivot table, and do your calculations not on
product totals but on FIFO layer totals.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=515149