ABC Classification - How To?

[edubois]

Hello and thank you in advance for your help!

I am using Excel 2013 Powerpivot with a three table data model.

I have tried various options/ideas but am enable to generate dynamic classifications A to C for my various locations at least by revenue and by year.

Here is a link to a test workbook for anyone suitable and willing to assist me:
https://filetea.me/t1sh9nF7UuBRfxOEnHY20nyDQ

Best regard

 

[edubois]

3 million and growing every month. Eventually this workbook will connect to a live feed but we're not there yet...

I appreciate the help and please rest assured that my silence was justified professionally (super busy with pressing customer facing business) and personally (moved).
I will promptly honor your attempts to help me form now on, and I am due to deliver to my boss something that works anyway

Please help me help you help me!

 

[marco.russo]

That's too much to implement a dynamic ABC classification, I think...

 

[edubois]

That's too much to implement a dynamic ABC classification, I think...

Please note that we need the classification to be based on annual revenue only and not day to day nor week to week nor month to month (actually, month to month may have a good value...).
So if dynamic ABC is based on one time calculated past year and ytd for current year we are good.
Do you see what I mean?

 

[marco.russo]

At this point I don't understand why you need dynamic classification. Can't you use the static pattern?