1 Reply Latest reply on Dec 4, 2018 1:56 PM by Roy Roongseang

    Top N in each category

    Roy Roongseang

      Hello,

       

      I am having trouble with getting the Top N within multiple categories. I was able to replicate my issue in the Superstore data set (attached).

       

      Using the Superstore example, I am trying to get the top 5 states to show up for each region and combine the "Others" in one line that can be collapsed by a parameter.

       

      I went through the Create Sets for Top N and Others - Tableau page but the problem is that the subset is applied for all states whereas I would like to have a subset for each region.

       

      For example, the South Region currently does not have any IN states but I want it to show the IN states as: Florida, Virginia, North Carolina, Georgia, and Kentucky.

       

      Desired output

      South: Florida, Virginia, North Carolina, Georgia, and Kentucky

      Central: Texas, Illinois, Michigan, Indiana, Wisconsin

      East: New York, Pennsylvania, Ohio, New Jersey, Massachusetts

      West: California, Washington, Arizona, Colorado, Oregon