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!

TOTAL( ) vs WINDOW_SUM( )

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( )?