...

TinyTableauTip: Adjust Grand Total

If you have a bar chart in Tableau and you add a Grand Total, a long bar appears that can make the rest almost disappear.

You can add the following calculation to remove the bar but keep the Total Value.

Use this calculation: IF SIZE()=1 THEN 0 ELSE SUM(Measure) END 

Image

Image

Image

Share this post:

Leave a Reply

Your email address will not be published. Required fields are marked *

Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.