0 Replies Latest reply: Feb 19, 2013 2:17 PM by Patrick clark RSS

    Ranking on subtotals on a pivot table.

      How to do the following ranking in pivot table:

      1. Create a ranking on the "partial Sums" field from the "Presentation" Tab?
      2. How to display just the Top ten and sorted by Rank in Ascending order?

       

       

      DescriptionPayor% Denials# of DenialsTotal Denial AmtRanks
      bankerChrysler45190$20
      550$150
      total240170Rank by total of denials  -2
      Loanhonda602000$15000
      2.51450$3000
      Total3450$18000Rank by total of denials  - 1

       

      any assistance will be appreciated

      Thanks.