How to do the following ranking in pivot table:
- Create a ranking on the "partial Sums" field from the "Presentation" Tab?
- How to display just the Top ten and sorted by Rank in Ascending order?
Description | Payor | % Denials | # of Denials | Total Denial Amt | Ranks |
---|
banker | Chrysler | 45 | 190 | $20 | |
| | 5 | 50 | $150 | |
| total | | 240 | 170 | Rank by total of denials -2 |
Loan | honda | 60 | 2000 | $15000 | |
| | 2.5 | 1450 | $3000 | |
| Total | | 3450 | $18000 | Rank by total of denials - 1 |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
any assistance will be appreciated
Thanks.