1 Reply Latest reply on Feb 21, 2018 11:58 AM by Jim Dehner

    Prevent Parameter Cross Filtering


      Hello all,


      I have a worksheet that has a parameter to filter using 5 dimensions. I am trying to duplicate the worksheet four more times to have a dashboard for each dimension.

      However, when I filter any of the worksheets using the parameter, the rest of the sheets are filtered as well.


      Is there a way to prevent that cross filtering by the parameter?



      Thank you so much.

        • 1. Re: Prevent Parameter Cross Filtering
          Jim Dehner


          Parameters are single valued user input that is global - i.e. affect the entire workbook - and remain constant until manually changed by the user


          that said you need to use the parameter in a calculation but  you don't need to put that calculation on every worksheet




          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.