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

# Tableau sub-total calculation

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!

 include1 include2 include3 include4 higher group lower group black percent of sub total red percent of sub total white percent of sub total Grand Total percent of total IP IP-1 70 23% 140 45% 100 32% 310 8% IP-2 90 43% 120 57% 0% 210 6% IP-3 500 56% 110 12% 280 31% 890 24% OP OP-1 210 30% 500 70% 0% 710 19% OP-2 410 66% 0% 210 34% 620 17% OP-3 150 56% 0% 120 44% 270 7% OP-4 140 24% 310 53% 130 22% 580 15% OP-5 0% 0% 160 100% 160 4% 0% total 3750 100%
• ###### 1. Re: Tableau sub-total calculation

Is this you need?

• ###### 2. Re: Tableau sub-total calculation

Thanks Luciano, but I need only one row for each "lower group". so the calculation is not what I need...

• ###### 3. Re: Tableau sub-total calculation

I recognize that this solution isn't ideal, but it is the only solution I came up with when I had a similar problem a while ago. It involves removing the Grand Totals from the first sheet and making a second sheet for the Grand Totals only. Then, you drag both sheets into a dashboard. Since the Grand Total table calculation is calculated as Table (Down) and the other ones are calculated as Table (Across) I think this might be your best bet.