HIDE vs EXCLUDE dimension values in Tableau

Hiding vs excluding in Tableau is not something I had really considered before, because it’s not something I had used much. But it came up in training the other day and it turns out the difference between these two is really important if you’re using table calculations!


In our client project this week, the dashboards we were looking at had some calculations containing the TOTAL( ) function. It left me wondering, what’s the difference between TOTAL( ) and WINDOW_SUM( )?