I'm not sure I understand why the Index doesn't work after the dimension has been sorted based on $ Opp. Would you be able to demonstrate what you mean by posting a sample workbook using superstore?
Here is an example using the same calculations to arrive at the $ Opp. If you are able to show me a way to rank the $ Opp to show the Top 10, it would be greatly appreciate.
Thanks for your help on this one.
$Opp_Rank_Example.twbx.zip 1.2 MB
A problem I've seen before - you're trying to partition one table calculation (rank) by another ($ Opp, which has table calcs from BDI).
Not easily solved, except if the data doesn't change.
While you can't sort product name by $ Opp in the dialog box, you can sort manually by clicking the $ opp column header:
This changes the product sort to manual in the order of $Opp
You then can filter on rank to show just the top 10, and adding in another filter still works.
Note that the $ Opp for "Telescoping..." has changed - I assume because the category filter has changed the totals - not sure though. That may be a problem. If your data changes, this method will not work.