7 Replies Latest reply on Aug 8, 2016 10:17 AM by swaroop.gantela

    Rank by Category by Quarter doesn't work when isolating a category

    Mary Kerrigan

      I have the following dashboard example: 

      When the user selects a quarter, the sheet at the top shows the sales by region and ranks them.  The bottom sheet is not affected by the filter but it shows the ranks of each region for each quarter.  I want the user to be able to select a region and see the ranks for each quarter for the selected region.  But what happens is this (selecting West, for example):

       

      I understand why this is happening, but is there a way to do this so that I get the results in the first example just for the West region?  I'm fairly new to Tableau.  Any help is greatly appreciated.  I have attached a sample workbook.