Editing Colors in a Tableau Highlight Table with Grand Totals

Data

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 →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

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
Germany
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