Editing Colors in a Tableau Highlight Table with Grand Totals


Editing Colors in a Tableau Highlight Table with Grand Totals

by Chris Sanders

When going through training, people are often introduced to highlight tables and are immediately intrigued. That’s because they allow us to create a standard crosstab but use color to call attention to certain values (high or low). But how do we edit colors once we create a highlight table, particularly when totals are involved? Let’s walk through the process.

Let’s add Ship Mode to Columns, State to Rows and keep a filter for only the top 10 states with highest Sales. Next, we can turn our crosstab into a highlight table by taking another copy of Sales to Color and changing Marks to Square. Results shown below:

Tableau Highlight Table

Soon after, we learn how to quickly bring grand totals to our crosstab by simply double-clicking the Totals option on the Analytics tab of the Data pane:

Adding Grand Totals to a Tableau Highlight Table

But what if we want to create a highlight table that ALSO shows grand totals? We should just be able to create our highlight table and bring in our totals, right? Not exactly. When we bring totals into a highlight table, we get a view that shows our Total Sales as the darkest cell. Who would have thought that Grand Total would be our highest value!?

Tableau Highlight Table: Default View After Bringing in Totals

How do we get around this? We need to tell Tableau to hide color from our totals by right-clicking on our Sum(Sales) associated with color navigating to the Total Using (Automatic) menu and selecting the Hide option:

Hiding Color from Totals in Tableau

And there we have it, a highlight table that also shows off our grand totals:

Tableau Highlight Table Showing Grand Totals

Keep in mind that when using this option, Tableau will assign whatever color “Zero” is associated with. In the highlight table above, light green is our 0 value, so our totals will default to that same light green.

More About the Author

Chris Sanders

Analytics Consultant
InterWorks Mentors the Next Generation of Analysts at Alteryx for Good Last week, Alteryx folks from all over the world donated their time in a concerted effort on behalf of Alteryx for Good. I had the ...
Gauges vs. Bullet Graphs in Tableau Quite frequently, students in training will ask “How do I make a gauge in Tableau?” While it’s possible, it’s not one of ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072


Love our blog? You should see our emails. Sign up for our newsletter!