• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

How do I add a rank number field to my pivot table?

How do I add a rank number field to my pivot table?

Problem

When you are sorting and ranking a field with a large amount of data items, it can be difficult to determine the number ranking of the current data item you are analyzing. Furthermore, you may want to turn your pivot table into hard values for further analysis. An integer field that contains the actual rank number of each data item could prove to be helpful in analysis outside the pivot table.

Solution

Select a cell in your pivot table. From the PivotTable toolbar, use the Pivot Table drop-down and select Formulas, Calculated Field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint