8 Replies Latest reply on May 1, 2015 9:01 AM by kettan

    Table Calculation - Calculate Across, Rank Down

    kettan

      Is it possible to rank years <table down> for a running total per year <table across>?

      What I want is to rank years into 5 pots for each month: { Best | Upper | Median | Lower | Worst }

      The purpose is to quickly see how we are doing year-to-date in comparison with previous years.

      See more in attached workbook.

      Table Partitioning, Summary Across, Compare Down.png