7 Replies Latest reply on Oct 19, 2018 9:02 AM by venkatram

# Conditionally Format the Grand Total Only with No Decimals

I think there has to be a formula that will let me accomplish "conditional formatting" of my numbers compared to the Grand Total number.  I am using the Table Calculation for % of Total.  I format the number to show as a percentage with one decimal pi

I want to show one decimal for each college's % of total but I want the 100.0 to show as 100.  Is there a way to do this?  I'm OK with losing the decimal sign next to the number if that lets me show the 100 in the Grand Total.

• ###### 1. Re: Conditionally Format the Grand Total Only with No Decimals

Hi Cindy,

Unfortunately formatting Grand Totals differently than the data is not possible. At least not easily, here's a thread. I'm not sure the workaround would be worth the effort but it's up to you.

Best,

Shiva.

1 of 1 people found this helpful
• ###### 2. Re: Conditionally Format the Grand Total Only with No Decimals

Hey Cindy,

We dont have option to do in tableau,however there is workaround to do this.

First exclude grand total in the report and create separate tab for grand total like below and combine them in the dashboard.

Steps to follow.

Created Grand Total in seperate view

Sub report with detail values

combine both details and grand totals in the dashboard and format accordingly.

1 of 1 people found this helpful
###### 2. RE: CONDITIONALLY FORMAT THE GRAND TOTAL ONLY WITH NO DECIMALS

ShivaRam, Thank you  - I ran into that page in my research as well and haven't had time to try to implement. It does seem like a lot of work for this and I will need to do this in almost every dashboard I build for enrollment. I'm going to Conference so I will put it in for an idea for a future Tableau upgrade.

• ###### 4. Re: Conditionally Format the Grand Total Only with No Decimals

Venkatram, yes, thank you for this.  Not ideal but is a good enough work around for now.    I do think Tableau needs to offer the separate formatting for the totals compared to the body of values.  It seems to work if you only have one measure - but multiples measures in the table and the ability to format the totals separately disappears. I'm using 10.4 - not sure if the newer versions have this capability yet.

• ###### 5. Re: Conditionally Format the Grand Total Only with No Decimals

I'm using 10.4 - not sure if the newer versions have this capability yet.

I've tried this on 2018.2 and can confirm that there is no out of box solution, however I remember reading it somewhere that this was available in older versions. (prior to 10 I think, although I'm not sure about.)

• ###### 6. Re: Conditionally Format the Grand Total Only with No Decimals

Thanks for the update!