Ranking of Values Across Years in a Pivot Table

Hi

I have a Povit Table based on Power Pivot.

I know how to rank a list of values for one year but I need to rank them based on the average across the years - Refer to attached workbook.

How could this done?

Allister

Perhaps this will be of some help.
Populate the cells to the left of the pivot table with the following formula:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.