ABC Report

[Richard]

Hi,

I have a spreadsheet with the total sales for one month on items that were
sold and have been asked to do an ABC report based on this info. We want to
see how many items make up 80%, 15% and 5% of the total sales for the month.
Then categorize those items as A, B, and C items. Is there a formula that
can designate each item as an A, B, or C item?

Thanks,

 

[Herbert Seidenberg]

Using staggered Pivot Tables:
http://www.savefile.com/files/1547002