7 Replies Latest reply on Oct 22, 2018 6:30 AM by Jalen Asperger

Calculate Relative to Column Total

Hello,

I am attempting to use a column total (table calculation) as part of another calculation. Basically, I want to use a calculation to be able to color cells relative to the column total for that row. So if column one has a percentage of 5.88% and column two has a percentage of 0.72% and the overall total for that row is 3.28%, I want to use a calculation to subtract the column percentages from the total and use that to color the cells. So the calculation would result in the column one value of 5.88% to be colored with a value of 2.6% (5.88% - 3.28%) and the column two value of 0.72% would be colored with a value of -2.56% (3.28% - 0.72%). I'll attach a packaged workbook to help explain things better.

Basically I just want to create a calculation to subtract the total column percentage for each row from the column percentage of the cells of each row.

Hopefully that explains things, but let me know if I can provide any more information.

I'm using Tableau 2018.1.1.