Hello, I am trying to create an ABC analysis for some data.
I am using the book "Microsoft PowerPivot for Excel 2010 Give Your Data Meaning" which gives the steps, their data is pretty simple.
My data is a little more complicated.
I have the sales data broken down by "Market", "Company","Category", "UPC" and "Period Description".
What I am trying to do is create an ABC analysis of sales of the UPCs of each Company for each "Period Description".
Where I am having an issue is when I create the cumulative total for the "UPCs" for "Company" and "Period Description", I get the cumulative for all companies and all Period Description. I just need the cumulative total for UPC, Company and Period Description
I have uploaded a copy to Skydrive.
Could someone please help me out?
Thank you
https://skydrive.live.com/redir?resid=84AA25B86224666C!142&authkey=!AG6UZx_FiOwprKU
I am using the book "Microsoft PowerPivot for Excel 2010 Give Your Data Meaning" which gives the steps, their data is pretty simple.
My data is a little more complicated.
I have the sales data broken down by "Market", "Company","Category", "UPC" and "Period Description".
What I am trying to do is create an ABC analysis of sales of the UPCs of each Company for each "Period Description".
Where I am having an issue is when I create the cumulative total for the "UPCs" for "Company" and "Period Description", I get the cumulative for all companies and all Period Description. I just need the cumulative total for UPC, Company and Period Description
I have uploaded a copy to Skydrive.
Could someone please help me out?
Thank you
https://skydrive.live.com/redir?resid=84AA25B86224666C!142&authkey=!AG6UZx_FiOwprKU