4 Replies Latest reply: Jul 28, 2011 9:18 AM by mhamberg RSS

    Add column with ascending numbers

      I have a pivot table that shows totals in the order that I want to show them.

      I'd like to add a column at the beginning that simply enumerates the rows that are already there (so 1,2,3,4,...) just to help people see the ranking of each row (similar to the row numbers on the left in Excel).

      Is there an easy way just to add these numbers? I'd use the rank feature but my columns are already complicated dimensions using multiple ranking calculations.