4 Replies Latest reply on Aug 31, 2016 12:20 AM by Biju J

    Table calculation on total percent

    Biju J

      I have a created a set in tableau like this

       

      Measuresname

      count(distinct companyid)20
      count(distinct projectid)30
      count(distinct taskid)50
      total (count(distinct companyid)+count(distinct projectid)+count(distinct taskid))100

       

      I have given the calculation I have done in each column

      I need to do a table calculation for total percentage in next column. How to do that ,like this

       

      Measuresname

      %
      count(distinct companyid)2020%
      count(distinct projectid)3030%
      count(distinct taskid)5050%
      total (count(distinct companyid)+count(distinct projectid)+count(distinct taskid))100100%