February 12, 2025
Advanced Calendar Heat Maps in Tableau (No More Workarounds!)
February 4, 2025
How to Exclude Reference Lines from Grand Totals in Tableau
Ever added a reference line to your Tableau visualization, only to see it appear in the grand total row, even when it doesn’t make sense?
If your grand total uses a different aggregation than your main data (e.g., SUM vs. AVG), the reference line can be misleading.
Unfortunately, Tableau doesn’t offer a simple way to exclude it—but there’s a trick to removing it while keeping your totals visible.
In the video below, I’ll walk you through the step-by-step solution to remove reference lines from grand totals.
Want to become an advanced Tableau user?
Unlock your full potential with Next-Level Tableau, the ultimate training program for Tableau users. Gain access to expert-led tutorials, live sessions, and a supportive community designed to help you master advanced skills, create stunning dashboards, and achieve your career goals.
Learn more and take your Tableau skills to the next level today at nextleveltableau.com.
Unsure? Sign up for my free course at starter.nextleveltableau.com.