Josh,

What you need is to change the  Adressing of your Rank Table Calculation. This way you will give a single rank for every Product without restarting the ranking for every region having sales on the product.

You can also change the order of the region by right-clicking on the Region pill and set the Sort options.

Michel

ps:  next time try to post a packaged workbook (.twbx) instead of a .twb. even if you use  the Superstore.xls.  You will increase your chances to get an answer

Josh,

Michel's approach should work.  Is it possible that you've got a different setup on the filter calculation?

If you just want to filter to the Top N, there are some other options:

1. You can also use a calculated Set to accomplish your goal here.  If you right click the Product field you can select "Create Set" and then use the Top tab to create a set based on the Top N products by Sales.  You'll have to use an additional calculated field to reference the set and use in the filter.
2. You can use a Top N filter on the products field.  That's probably the easiest approach.

I've attached a workbook to demonstrate Michel's approach and the other possibilities.

Regards,

Joshua

By the way, 8.1 will have a nice RANK function that will make life a little easier!

You're welcome!