Hi There,
I have a long list of accounts with revenue generated in the past 3 years in separate columns, I have created individual pivots to how the top 10 accounts in each year. Is there are way to show in once pivot or a formula to show the top 10 accounts but their position in each year. e.g. "Account A" is number 1 in 2013, but in 2014 "Account A" has dropped to number 5. I would like to show the consistant accounts as well as the new accounts each year with the revenue.
Not sure if I have explained myself properly.
Any help will be greatly received.
I thank you in advance.
F
Bookmarks