Finding Monthly Usage
I have been hacking away at this for a while, and I feel that I'm at a dead
end on my own, any help is greatly appreciated.
I have records of parts and the dates and quaity of usage. I am trying to
total the number of each part used for a month, and then have something like
a pivot table showing each part listed down, months listed across, and
quantity used in the data. There is a record for each time the part is used.
Here is a small sample of my data.
Part # Description
Issue Date TRL_QTY
401083 Head Stop Brush, Folder 11/9/05 3
401083 Head Stop Brush, Folder 11/13/05 3
401083 Head Stop Brush, Folder 2/13/06 8
401083 Head Stop Brush, Folder 2/13/06 -2
401115 Oven Gasket, P4
11/26/05 12
401137 Blade, Tidland Slitter System, Press 43 12/6/05 2
401138 Blade, Tidland Slitter System, Press 43 POWDER 6/1/05 2
|