Here we have data that represents one month of sales for a camping store.
it’s possible for you to see the store sells tents, backpacks, headlamps, and so on.
I’m going to rename this field “Sales,” and set the number format to Currency.
Now, what if I want to add an actual rank value to the pivot table?
This is easy to do.
The first step is to add the field you want to rank in the Values area.
Now I need to change the display to show rank.
This is done with Value Field controls under Show Values As.
In this case, we want largest to smallest.
Now, whenever you rank with a pivot table, you better set a base field.
This will be the field that you are using to summarize data, which in this case is Item.
Now when I save these controls, we have a rank value in the pivot table.
Now when I refresh the pivot table, we see updated rank values.
I’ll undo that change.
Keep in mind if you change the field used to summarize data, you’ll break the rank tweaks.
For example, if I replace item with state, the Rank now shows errors.
To fix this problem, just update the base field setting.
In this case, I need to change the base field to State.
Finally, notice there is no requirement to keep the original amount field in the pivot.
If I remove this field, the ranking still works fine.
