Tableau Tip - Totals and Subtotals - 3 ways to add | sqlbelle

In this quick tip, we will walk through how to add/remove totals and subtotals (3 ways). I will also demonstrate a not-so-obvious option available for totals/subtotals.

Additional Tutorials

Table Calculations

Level of Detail (LOD) Expressions

Calculations Playlist

Sets and Set Actions

Top 1-5 LOD Expressions

Dates

Filters:

Sample Certification Exam Questions

[alainponroy]

Thanks for this very interesting video 🙂

[Rkcuddles]

Ok love the video but pissed at tableau expecting me to go under format to change the name of my totals that aren’t totals.

How about a video on how to tell rename those column names. I know to set aliases for the metrics but if I want to say primary category I can’t do it…

[Raghavendraginka]

Thanks for the video can you please make video on complete tableau calculations part

[shamukesarla]

Hi, Could you make a video on this if it is possible. How to hide only one South region subtotal sales and other states subtotals sales should remain same to display in the view?

[maydaacosta]

I would like to find out if there is a way to add a Summary at the Segment level that includes a breakdown summary at the Sub-Category (basically collapsing or ignoring the Category)

[sumitbarua]

Thanks mam ..
One request tho mam, can you build full fledged project in Tableau which we can represent in our cv to get hired..
Because every company hires experience rather than fresher, so projects is the only thing we can get hired.

[HKR_RKN]

Can we dynamically populate column in a worksheet based user input. Say user input 4 then I need to populate default column plus 3 prior days columns?

[anaskunda]

There is a missing feature regarding subtotals though, we cannot rename the subtotals based on their respective categories.

Any solution/alternative for this ma'am?

[hmloldtableau]

Hi, I have a question because I saw an example in Power Bi, but I only use Tableau: Say your sub-category column grand total is 100M and you are showing all the sub-categories, but the business case ask to show top 3, suppose bookcases is 10M, chairs is 5M and tables is 3M but the Boss is asking to preserve the 100M as the total. This applies a any Top N. The intent is to keep the totals for comparison. please advise, again a friend showed to me in Power BI and I am doubting Tableau can do the same.

[rajmahal]

Can we show Grand Total and also Average

[dasniharranjan]

sometimes we got wrong subtotal and if the field is already aggregate we don't get chance to select total using option... could you please explain this on ur video....