2 Replies Latest reply on Apr 14, 2018 4:49 AM by Jim Dehner

    Prevent a quick filter from impacting my Table Calculation

    Jose Alvarenga

      Hello everyone,

       

      I want to be able to compute market share across 5 territories, however, I want to be able to filter without this market share % changing. Thanks to a lot of you, I have found a way to use the LOOKUP(ATTR([DIMENSION]),0) but the one problem I am having is I am unable to use this in a dashboard and have it apply to all sheets within that dashboard. Can someone please help?? I'm open to doing it this way or any other more efficient way.

       

      Side note - I have also tried the creating a duplicate source and that would work, however, I wouldn't want to be re-doing everytime data gets updated.

       

      Thank you SO much!