2 Replies Latest reply on Apr 19, 2018 9:14 PM by Mark Holtz

    Can you use only relevant values from one sheet to filter another sheet?

    Michael Popiolek

      Hello,

       

      I am trying to filter a pie chart on one sheet that contains store locations based on the employee selected on another sheet.

       

      My charts should look like this in the end:

      I tried to selecting an employee name and setting their store location filter to only relevant values. I then applied the store location filter to selected worksheets, but the selected worksheets are still showing all store values. Does anyone have any ideas on how to accomplish this level of filtering? I tried playing around with parameters but they lack the ability to be dynamic.