2 Replies Latest reply: Jun 11, 2009 11:22 AM by flovit88 RSS

    Adding a "rank" column to a pivot (or straight) table

    banciu

      Is it possible to add a column generically called "Rank" to show the position of a line in a pivot or straight table?

      Practically I want to create a top with the cities sorted descending by their population:

      Rank City sum(Population)

      1 New York 20 000 000

      2 Los Angeles 15 000 000

      3 Washington 7 000 000

      .............................................................

      100 Atlanta 150 000