3 Replies Latest reply on Sep 24, 2018 7:54 AM by venkatram

    Calculate Percent of Grand Totals with LOD

    Alex Zelman

      Hello,

      I'm new to Tableau and ran into this issue.

       

      I have a simple table and want to keep the data as is and add a % of total to tooltip.  It works fine using FIXED LOD as a percent of each cell divided by TOTAL number of count regardless of bucket.

      It works fine until you want to filter out a specific city - the percent stays the same if you remove a city or multiple cities.

       

      I understand that it's because FIXED expressions are happen before the Dimension filters and therefore the % stays the same.

      For example - Miami is at 25.79% ( see tooltip).  If Chicago is removed it's still showing 25.79% which needs to reflect only data that still in the view and therefore should be 55.55%.

       

      Trying to see if there is any workaround to solve this?

       

      Thanks in advance.