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

    Prevent Parameter Cross Filtering

    ahmed.arafat

      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

          Hi

          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

           

          Jim

           

          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.