Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
All Courses
  • Free Training Courses
  • AI for Your Role
  • AI & Machine Learning
  • Cloud Tech
  • Data Science
  • DevOps
  • Dashboarding/BI
  • Database
  • WebDevelopment
  • Programming & Coding
  • MS Office & Workplace Productivity
  • QA & Test Automation
  • Professional & Career Development
  • Cyber Security

Courses

  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
  • Microsoft Azure for Beginners
  • AWS Cloud for Beginners
  • Oracle SQL Fundamentals
  • Tableau Fundamentals
  • Power BI Fundamentals
Explore All Programs

Courses

  • AI Essentials
  • AI for Administrative Professionals New Launch
  • AI for Managers & Team Leads
  • AI for Data Analytics & Power BI
  • AI for Software Developers
  • AI for Database & SQL Professionals
  • AI for Project Managers
  • AI for Marketing Professionals
  • AI for Sales Professionals
  • AI for HR Professionals
  • AI for Finance Professionals
  • AI for Customer Support Professionals
  • AI for QA & Test Engineers
  • AI for IT Support & System Admins
  • AI for Cybersecurity Analysts
  • AI for Job Seekers
Explore All Programs

Courses

  • Learn Claude Basics New Launch
  • Learn Claude Advanced New Launch
  • Applied Artificial Intelligence (AI) New Launch
  • AI for Workplace Productivity
  • Azure Fundamentals with AI
  • Advanced Microsoft Azure with AI
  • AI Implications for Business Strategy
  • Mastering ChatGPT & Generative AI Tools
  • Prompt Engineering
  • Agentic AI Solutions
  • AI Product Management
  • AI for Quality Control
Explore All Programs

Courses

  • AZ-900 Azure Fundamentals
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
Explore All Programs

Courses

  • DP-100 Data Science on Azure
Explore All Programs

Courses

  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Explore All Programs

Courses

  • Business Analytics: From Data to Insights New Launch
  • Power BI Advanced
  • Data Analytics with Excel
  • Tableau Beginner
  • Tableau Data Consumer
  • Alteryx & Tableau
  • Tableau Advanced
  • Tableau Certification prep
  • Power BI Beginner
  • Cognos Analytics
Explore All Programs

Courses

  • SQL Server for Beginners
  • SQL for Analysts
  • SQL Server Advanced
  • SQL Server T-SQL Programming
  • SSIS
  • Oracle SQL for Beginners
  • Oracle PL/SQL
  • Oracle SQL Advanced
  • Big Data with Hadoop: HDFS, MapReduce & Ecosystem Tools
  • MS Access
Explore All Programs

Courses

  • Angular Frontend Development
  • Spring 5 Framework
  • Full Stack Web Development
Explore All Programs

Courses

  • Learn Python
  • Python PCEP
  • Python PCAP
  • JavaScript & jQuery
  • Java Certification
  • Python for Data Science
  • Machine Learning with Python
Explore All Programs

Courses

  • Analyzing Data with Excel New Launch
  • Workplace Digital Skills
  • Excel Beginners to Advanced Trending Now
  • Excel for Finance
  • Excel for HR
  • Workplace Computer Skills
Explore All Programs

Courses

  • Selenium QA Automation (Java)
  • Selenium QA Automation (Python)
  • API Testing
  • QA Automation with Python (Advanced)
Explore All Programs

Courses

  • Scrum Master Certification
  • Lean Six Sigma Green Belt Certification
  • Business Analyst
Explore All Programs

Courses

  • Cyber Security Foundations for Beginners
  • Computer Networking for Cybersecurity
  • Windows & Linux Security Administration
  • Ethical Hacking & Penetration Testing
  • Artificial Intelligence (AI) in Cybersecurity
Explore All Programs
  • About Us
    • OCA Skill Sprint Method
    • Meet the Founder
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

 

  • info@ohiocomputeracademy.com
  • +1 866-648-7284
  • Home
  • About Us
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Find With Us
  • Home
  • Blogs
  • Tableau
  • How to Create Totals in Tableau

How to Create Totals in Tableau

Aggregations or Totals are important in any Visualization application. In Tableau, it is easy to display totals in your charts. There are many variations to creating Totals and Subtotals. In this article, we will discuss how to create Totals in Tableau.

Adding Grand Totals and subtotals in Tableau

In Tableau, Totals can be displayed by using the options available in the Analysis menu. We can display Grand Totals in Rows and columns. Subtotals can also be displayed for various dimensions.

  1. To explain this concept, I will connect to Tableau provided Sample-Superstore.xls. If you are new to Tableau, learn how to connect to excel datasource and create a chart. 

  2. Create a Table visual by using dimensions – State and City on the Rows and a measure – Sales on the Text (under Marks). For display purposes, I will filter the data for the States – Maine and Vermont, as these states have less number of Cities.  

  3. To add Sub-totals for each State, navigate to Analysis >Totals > Add All Subtotals.

  4. Next, to display the overall grand total for all states, navigate to Analysis > Totals > Show Column Grand Totals.

                                                                       Totals option under Analysis menu
  1. The resulting table displays subtotals for each state and a grand total at the bottom, representing the total sales across all selected states.

                                                                      Subtotals and Grand Total for States

Creating Subtotals for different dimension levels

  1. In the existing table, drag Category, Sub-Category, and Segment to the Rows shelf, placing them after City. The table now contains multiple dimension levels: State, City, Category, Sub-Category, and Segment.

  2. To display subtotals at the applicable dimension levels, navigate to Analysis > Totals > Add All Subtotals. Tableau will calculate subtotals for the nested dimensions. The Grand Total enabled in the previous section will remain visible.

  3. Notice that Tableau displays the word Total in the subtotal labels at different levels, which can make the table difficult to read. To customize these labels, right-click a subtotal label and select Format. In the formatting pane, locate the Totals label setting and change the displayed text as needed.

Sample rows after adding the Subtotals at different levels and changing the Subtotal label

Removing the Subtotals from a dimension level

In some cases, you may want to remove the Subtotals from a specific dimension.

We can always navigate to the Analysis menu and from the Totals select Remove All Subtotals. But this will remove all of the Subtotals from the table. If you want to remove subtotals at a certain level, say for e.g. from the Sub-Category level, then this solution will not work.

To remove a subtotal at a specific dimension level, on the Rows, right-click on that specific dimension and uncheck subtotals.

                                                                            Removing subtotals for the Sub-category dimension.

Note: Tableau allows you to enable or disable subtotals for individual dimension levels. However, the Subtotal option is not available for the innermost dimension on the Rows shelf because there is no additional dimension nested beneath it to summarize.

For example, when the dimensions are arranged as State, City, Category, Sub-Category, and Segment, you can control subtotals for the outer dimensions, but not for Segment.

When Totals are used in the above fashion, Tableau is calculating them automatically. If you wish to control it or want to calculate it in a different way, then navigate to Analysis menu and from the Totals select Total All Using.

Changing How Totals Are Calculated in Tableau

By default, Tableau calculates grand totals and subtotals automatically based on the measures and aggregations used in the visualization.

If you want to change how the totals are calculated, navigate to Analysis > Totals > Total All Using. You can select from the available options, such as Automatic, Sum, Average, Minimum, or Maximum.

For example, selecting Average calculates the totals using the average instead of the default aggregation.

                                                                                      Control how Totals are calculated

If you follow the above mentioned steps you can create effective Totals and Sub-totals based on visualization requirements.

Learn More About Tableau

Want to develop your Tableau skills beyond creating totals and subtotals?

At Ohio Computer Academy, we offer hands-on, instructor-led Tableau training covering data visualization, calculations, filters, parameters, and interactive dashboards. Training is available live online or in person in Dublin, Ohio.

Explore Our Tableau Training Courses

For additional examples and practical learning, explore my book Dashboarding with Tableau.

Like
Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.

0 Comments

Add Your Comment

Post a Comment

Required fields are marked *

✅ Thanks for adding your comment! It will appear after moderation.

0 Comments

Related Blogs
View All Blogs
Why learning Tableau is important
Read More
Tableau Components
Read More
Types of Files in Tableau
Read More
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

Registered with the Ohio State Board of Career Colleges and Schools — School Registration No. 2395

About Us
  • Contact Us
  • Our Story
  • Training Gallery
  • Reviews
  • Books
  • Greater Columbus Training Center
Trainings/Services
  • Course Categories
  • Learning Paths
  • Frequently Asked Questions
  • AI Advantage
Contact Us
  • Phone:+1 866-648-7284
  • E-mail: info@ohiocomputeracademy.com
  • Address:

    Dublin, Ohio
    5900 Sawmill Road, Suite # 150, Dublin, OHIO 43017 USA

Thank you
Failed
Free Training Courses
  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
AI Courses
  • Claude Basics
  • Claude Advanced
  • AI for Workplace Productivity
  • Prompt Engineering
  • Agentic AI Solutions
  • AI for Quality Control
Cloud Tech
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Technical Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
DevOps
  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Dashboarding/BI
  • Tableau Beginner
  • Power BI Beginner
  • Data Analytics with Excel
Database
  • Oracle SQL for Beginners
  • SQL for Analysts
  • SQL Server for Beginners
MS Office & Workplace Productivity
  • Workplace Digital Skills
  • Excel for Finance
  • Excel for HR
  • Excel Beginners to Advanced
  • Workplace Computer Skills
Learning Hub
  • Begin Your IT Career
  • Generative AI & Workplace Productivity Foundations
  • Claude AI Learning Path
  • Data Visualization Foundations
  • Data Analytics Career Path
  • AI for Business & Data Applications
  • Programming Foundations & Development Path

© 2026 Ohio Computer Academy. All rights reserved.

  • Privacy
  • Terms & Conditions