0
In regards to making a Pivot Table. When I'm trying to use the Top 10 filter, I am unable to even see the option for Average by Rank, only Sum of Rank. What is preventing me from being able to select it?
0
In regards to making a Pivot Table. When I'm trying to use the Top 10 filter, I am unable to even see the option for Average by Rank, only Sum of Rank. What is preventing me from being able to select it?
0
To add a column with Average by Rank in your pivot table, follow these steps:
For example, if you're trying to do this with a column labelled Quantity, add a second column next to it labelled Quantity2 (or whatever).
This adds a ranking to your pivot table.
Note: Obviously, ranks will change when you filter your Pivot Table.
If I've misunderstood your question, please feel free to clarify.