Totals in Tableau: Learn how to display subtotals and totals in Tableau

👉🏻 Download Our Free Data Science Career Guide: bit.ly/2POLaN8
👉🏻 Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3iKD0lv
Let's learn how to display subtotals and totals in Tableau.
Most executives prefer receiving tables that contain totals and subtotals. This makes it easier for them and helps them digest information in a faster way. In this lesson, we will learn how to add subtotals and totals in Tableau.
That’s fairly easy to do. I’ll go to “Analysis”, then “Totals” and will select “Show column grand totals”. The totals we just added are for the entire period 2016 and 2017. That’s not really useful, is it? Whenever a person is interested in a company’s sales or gross profit, they want to know how much it made in a specific year, and whether it performed better than the year before. A company will also want to know how its year’s sales compare to other companies.
So, I’ll go to “Analysis”, “Totals”, and unclick the “Show column grand totals” to remove the total we just added.
What I can do differently the second time around is opt for “add all subtotals”, and this will give me the total figures for 2016 and 2017 separately.
Now we can read the table easily. The fictitious numbers we see here help us compare 2016 and 2017, and give us a good idea of what the actual sales were for that period.
► Consider hitting the SUBSCRIBE button if you LIKE the content: www.youtube.co...
► VISIT our website: bit.ly/365ds
🤝 Connect with us LinkedIn: / 365datascience
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.
We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.
Check out our Data Science Career guides: • How to Become a... (Da...
#Tableau #spreasheets #statistics

[@365DataScience]

👉🏻 Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3iKD0lv