2 Replies Latest reply on Feb 16, 2017 1:31 PM by Stephen Shepperd

    Calculating percent of total when SUM is different from total - Tableau 10.1

    Erik Nelson

      I have a database with only partial data that I am allowed to view.  I can see 4 of the 6 groups and know the total, but do not know what the 2 groups I cannot view contribute individually on a lower level.

      Below is what I can do in Excel by using an absolute reference to the total sales of 298 but cannot translate it to Tableau:

        

      GroupSalesPercent of Total
      A258%
      B3913%
      C4515%
      D8930%
      Eunknown34%
      Funknown
      Total298

      100%

       

      I have tried using EXCLUDE as well as ATTR but end up with errors on combining accumulated data.

      This is similar to what my database looks like:

         

      GroupItem NumberSales
      AA23418
      AA2357
      BA23620
      BA23710
      BA2389
      CA23920
      CA24025
      DA24146
      DA2429
      DA24312
      DA24422
      All groupsall items298