4 Replies Latest reply on Aug 24, 2016 1:54 PM by Emily Shen

    Tableau sub-total calculation

    Emily Shen

      Hi,

       

      I need two kinds of table calculations on one sheet, not sure if this is possible. so first, I want to calculate percent of total for each "lower group", that's column "include4", so total of each row divided by total of the table. secondly, I want to calculate "include1"-"include3", which is number in each cell divided by row total. Any suggestion is much appreciated!

       

              

      include1include2include3include4
      higher grouplower groupblackpercent of sub totalredpercent of sub totalwhitepercent of sub totalGrand Totalpercent of total
      IPIP-17023%14045%10032%3108%
      IP-29043%12057%0%2106%
      IP-350056%11012%28031%89024%
      OPOP-121030%50070%0%71019%
      OP-241066%0%21034%62017%
      OP-315056%0%12044%2707%
      OP-414024%31053%13022%58015%
      OP-50%0%160100%1604%
      0%total3750100%