3 Replies Latest reply on Mar 16, 2017 8:20 AM by Tom W

# Rank/Index() not linked to other fields after drilling down in hierarchy!

Hello,

I have a simple question here that I haven't been able to figure out. I'm currently building a report for my boss. I need to show top 50 dollar amounts. I created the calculation for rank but it's not linked to the field dollar amounts after drilling down in the hierarchy. Works fine once I roll up the hierarchy. Here's a snippet of what I'm seeing. Due to an agreement with my employer I cannot share information.

Notice how number 3 should be number 1.

Any suggestions or ideas?

Thank you!

• ###### 2. Re: Rank/Index() not linked to other fields after drilling down in hierarchy!

Hey Tom,

I've added the attachment, are you able to help?

• ###### 3. Re: Rank/Index() not linked to other fields after drilling down in hierarchy!

In your example, are you looking for the top 50 "Customer ID"'s based on Sales or top 50 "Customer Names" ?

Right now you are sorting Customers by their sales amounts and because you have Customer ID in the report, the way you have it setup it's going to show you the top 50 Customer ID records for customers based on their sales.

If you're trying to show the top 50 customer ID's, swap Customer ID to be the leftmost on the rows shelf and apply the Sales sort on that field, not on the customer name.

If you're trying to show the top 50 Customer Names, edit your table calculation for Rank and change it to 'Compute Using' > Specific Dimensions > Customer Name and Customer ID selected, change 'At the level' to Customer Name.

If you're trying to show the top 50 customer ID's WITHIN the customer name, edit the table calculation for Rank and change it to compute using > specific dimensions > Customer Name and Customer ID selected, change at the level to Customer ID and restarting every to Customer Name.

You could also use a different approach by using the TOP n filter:

If you're looking for the top 50 Customer Names, remove the RANK filter and drop Customer Name onto the filter shelf, then click the top tab and set it up like: