Tableau YTD Table Calculations

This article shows how to perform the Tableau YTD table calculations with an example. We can also call it the year to date table calculations. 

To explain then Tableau YTD Table Calculations, drag and drop the Order Date into the Columns Shelf and expand the Hierarchy to display the Quarterly Sales. Next, add the English product Subcategory name to the Rows shelf and the Sales Amount to Text Shelf.

Add Order Date to the Filters section and uncheck 2010, 2011, 2012, and 2014. Next, select and drop the Quarter from Columns to Color Shelf using the Control button. Then, use Analysis Menu to add Row and Column Totals.

Matrix report

How to Perform the Tableau YTD Table Calculations?

Under the Marks shelf, click the down arrow beside the Sum of Sales Amount, click Quick Table Calculation, and then select the YTD total.

Calculate Tableau YTD using Quick Table Calculations

It calculates the Year to date total for each quarter.

  • Bike Racks
    • Q1 = 8,280
    • Q2 = 8,280 (Q1) + 8,280 (Q2)
    • Q3 = 8,280 (Q1) + 8,280 (Q2) + 8,760 (Q3)
    • Q3 = 8,280 (Q1) + 8,280 (Q2) + 8,760 (Q3) + 11,640 (Q4)
Tableau YTD Table Calculations Output

Let me change the Tableau YTD calculation computing from Table (across) to Table(Down). It calculates the YTD for each quarter. For Q1

  • Bike Racks = 8,280
  • Bike Stands = 8,280 + 6,996
  • Bottles and Cages = 8,280 + 6,996 + 9,367
  • Caps = 8,280 + 6,996 + 9,367 + 3,335
Tableau YTD Table Calculations compute using table down

If we change it to Table across and then down, it goes continuously from Bike racks Q1 to Q4 and the following product subcategory. For instance, 

Bike Stands = 36,960 + 6,996

Table across and then down option

Tableau YTD Table Calculations Example 2

Let me replace the Product Subcategory from the Rows shelf with the English Country Region Name. Next, add the Color group to the Row Shelf. Within the Color group 

Multi = Multi, NA, Red, and White Color.

cross tab report

Let me choose the Quick Table Calculation as the YTD total.

Tableau Quick YTD Table Calculations

Now, you can see the multi-level year to date table calculations.

Multi-Level year to date

Change the computing to table(down). It calculates the YTD total for each quarter irrespective of Color group and Country.

Tableau YTD Table Calculations compute. table down

Pane across then down: Tableau calculates the YTD total for each Country in a table. For Australia, it starts with Black color and calculates the total of all quarters, then goes to Blue color, and so on, up to the fourth quarter of the Yellow color. It again restarts for Canada.

Tableau YTD Table Calculations Compute using Pane Down output

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.