2 Replies Latest reply on Oct 9, 2018 7:51 AM by meenu choudhary

# Add a Custom % Column to a Table

Hello!

I have a table that measures student grades as follows:

The table adds the High, Medium and Low Scores and sums them in the Total Completed column. It ignores the Not Rated values. The Grand total does adds all of the values. The total % completed is then the Total Completed / into the Grand total.

Can you please show me how to recreate this calculation in a Tableau table? I can only produce a table up to the Grand Total column. I do not know how to add the last two columns.

Thank you so much!!!

 Region High Moderate Low Not Rated Grand Total Total Completed Total % Completed South 90 11 8 51 160 109 68% North 78 13 6 54 151 97 64% West 0 0 0 1 1 0 0% East 128 14 4 64 210 146 70%
• ###### 1. Re: Add a Custom % Column to a Table

Are High, Moderate, Low columns measures? If yes you could just add them as

Total Completed: SUM(High)+ SUM(Moderate)+ SUM(low)

Total % Completed: Total Completed/Grand Total

If they aren't individual columns but values of a dimension, then

Total Completed: SUM(if [dimension]<>'Not Rated' or [dimension]<>'Grand Total' then [value] end)

Total % Completed: Total Completed / SUM(if [dimension]='Grand Total' then [value] end)

• ###### 2. Re: Add a Custom % Column to a Table

Hello Manuel,

Assuming your data is in the same format that you have displayed, you can try below approach:

1. Grand Total = [High]+[Low]+[Moderate]+[Not Rated]

2. Total Completed  =  [High]+[Low]+[Moderate]

3. Total % Completed  = [Total Completed ]/[Grand Total ]

Right click on [Total % Completed]  -> Default Properties -> Number Format -> Percentage Arrange all the values as shown above in the image.