Top 5 chart showing Rank in two periods

[james227]

Hi,

I have a pivot table which restricts to the top 5 clients  by sales for current year. I want to show the client's rank from the previous year but not within the same group of 5 clients.

Currently:

It is ranking the group of 5 clients for the previous year.

Solution

I want to see the rank the this year's top 5 over the entire set of all clients from the previous year. If the client didn't exist in the previous year the label as a new client.