2 Replies Latest reply on Dec 14, 2016 3:01 PM by joe major

    Need to filter sales by category using sub-category totals

    joe major

      Hi there,

       

      I need to use either use a filter or parameter to filter categories by sub-category totals.

       

      I've attached a workbook using Tableau data.

       

      I have category in the Rows Shelf with sub category and Sum(sales) as the measure. 

       

      I need to filter the CATEGORY by sub-category TOTAL using a slider that has a range (for this example) 850,000 and 740,000. If the slider goes all the way down, nothing shows up, if the sider stops above 750,000, only Furniture and Office supplies shows up and leaves out Technology.

       

      I hope I'm clear. 

       

      Joe