1 Reply Latest reply on Mar 25, 2020 9:29 PM by Ken Flerlage

    Top five Manufacturer for top five Sub-Categories

    Kajal Gandhi

      Hello,

       

      I am trying to show the top five manufacturers for each Sub-Categories by Quantity sold.  I am able to achieve that by using the Rank function.  I also only want to show the top five Sub-Categories in my view and I am struggling with how I can achieve that. Below is what my view currently looks like,  I only want to see Binders, Paper, Furnishings, Phones, and Storage in my view as those are the top five Sub-Categories by Quantity sold. Any help would be greatly appreciated.  I am using the Sample Superstore data but I am attaching the packaged workbook here too.