5 Replies Latest reply on Dec 27, 2018 9:29 AM by Ganapathy Palanimuthu

    Using a filtered dimension across multiple sheets in a Dashboard

    Brian  Fase

      I have made a dashboard that has one sheet looking at the total inventory of line items and filtering out the line items that don't meet a quantity threshold.  I have another sheet on the dashboard that gives a breakdown of all the line items on rows and all the inventory locations in the facility in columns with quantity as the measure.  I am trying to have the dashboard setup so that only the filtered line items from the first sheet are shown on the second sheet.  It seems like this should be pretty simple but I am having a lot of difficulty.  When I try to apply the quantity filter to the second sheet it filters by the individual dimension column breakdown instead of the category total resulting in locations being filtered out that I want displayed.

       

      I recreated the dashboard as best I could using the superstore data as an example since I can't supply the original workbook.