1 Reply Latest reply on Jun 20, 2018 8:14 PM by Mahfooj Khan

    Dynamic Change in % Total On Filtering Dimension

    Ashwin Chandak

      Hello Tableau Community,

       

      I have a dimension, 'Category' and a measure, 'Total'.

       

      I am adding a table calc showing a % of total and have added a grand total

       

      The grand total shows 100% regardless of a filter on the category

       

      My goal is to have a grand total that reflects the total of the selected metrics (not 100%)

       

      so,

       

      Data:                  

       

      CategoryTotal
      A5
      B16
      C9
      e20
      TOTAL50

       

      % Total with All Categories

       

      Category
      %Total
      A10%
      B32%
      C18%
      e40%
      Total100%

       

       

      EXPECTED % Total with Filtered Categories

      Category% Total
      A10%
      B32%
      C18%
      TOTAL60%

       

       

          What I see:

       

      Category% Total
      A17%
      B53%
      C30%
      TOTAL100%