4 Replies Latest reply on Aug 22, 2018 7:01 AM by Tina Crouse

# Ranking by descending amount based on 3 dimensions

I am just having a heck of a time getting my ranking to work and no matter what I try it always gives me the top 5 over all and I want the top 5 by the plan, product showing the providers that are the top 5 and their dollar amounts. I put a .jpg out here and hope that is enough as I have a hard time with the size of my data and PHI laws posting example workbooks. I think I got an example WB together.

• ###### 1. Re: Ranking by descending amount based on 3 dimensions

One method would be to use the INDEX() Table Calculation to create a nested rank for each provider, then use it as a filter.

Attached is an example using superstore that's as close as I could get it to your screenshot.

Based on the screenshot, the compute using set up for the index would be something like this:

Specific Dimensions

At the level: Povider

Restarting Every: Product Line

Sort Order: Custom Sort

NonPar Allowed    Sum

Descending

For more information on adjusting the addressing and partitioning of table calculations, please see: Table Calculation Functions

Hope this helps!

Cheers,

• ###### 2. Re: Ranking by descending amount based on 3 dimensions

Looks like my superstore workbook didn't upload, so I recreated what I did in the anonymous.twbx that was uploaded.

• ###### 3. Re: Ranking by descending amount based on 3 dimensions

Tina,

You can create T|F filter as :

Put the column on filter shelf and choose TRUE.

Choose compute using as provider:

Again edit filter and choose TRUE.

Hope this helps.

• ###### 4. Re: Ranking by descending amount based on 3 dimensions

Both answers are correct. Thank you so very much.