your cart

How to apply table calculation filter to other sheet

      A dimension or measure filter can use in different sheet which give convenience to tableu end user by applying option.

      But sometimes user want filter based on a table calculation such as only show % of total more than 5% by sub-category or by state. But you can't apply filter to 2 different sheets because table calculation based on current sheet.

      Do we have to create filter on each sheet? NO WAY. We can use a parameter to fix it.
      First we create a table calculation:
      % of Total: SUM([Sales]) / TOTAL(SUM([Sales]))
      Then we create a parameter:

      We create another calculated field to use this parameter:
      % of Total Filter: [% of Total]>=[% of Total Parameter]
      Then we drag it to filter and choose "True" and choose "Show Parameter Control".

      Then the sheet will only sub-category whose % of total equal or more than 6%.

      Then we duplicate this sheet and replace sub-category with state. Same rules apply to this sheet. Then put 2 sheets into a dashboard, when you change parameter, 2 sheet will change based on the value.

Blog Category