Compute using (table across, down) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate Running Total with Compute Using Table Across

You have a sales table with monthly sales data. You create a calculated field for running total using Compute Using: Table Across. What will be the running total value for March if the sales for Jan, Feb, and Mar are 100, 150, and 200 respectively?

A 200

B 450

C 150

D 100

💡 Hint

Running total sums values from left to right across the table.

With Compute Using: Table Across, the running total adds sales from January through March: 100 + 150 + 200 = 450.

❓ visualization

intermediate

Identify Correct Compute Using Direction for Yearly Sales Growth

You want to visualize yearly sales growth by region in Tableau. Which Compute Using option should you choose to calculate growth down the table (by year) for each region?

A Pane Down

B Pane Across

C Table Down

D Table Across

💡 Hint

Growth by year means moving vertically down the table.

Table Down computes calculations vertically down the table, which fits yearly growth by region.

🎯 Scenario

advanced

Troubleshoot Unexpected Results with Compute Using Table Across

You created a calculated field for percent of total sales using Compute Using: Table Across. However, the percentages do not add up to 100% across the row. What is the most likely cause?

A There are hidden filters limiting data in some columns

B Compute Using should be set to Table Down instead

C The data source has duplicate rows causing errors

D The calculation is missing an aggregation function

💡 Hint

Check if all columns in the row are included in the calculation.

If filters hide some columns, the total sum across the row is incomplete, so percentages won't sum to 100%.

🔧 Formula Fix

advanced

Fix Incorrect Compute Using Direction Causing Wrong Running Total

You created a running total calculation but it sums sales down the table instead of across. Which change fixes this?

A Change Compute Using to Table Across

B Change Compute Using to Pane Down

C Change Compute Using to Table Down

D Change Compute Using to Pane Across

💡 Hint

Running total should sum left to right across columns.

Setting Compute Using to Table Across sums values horizontally, fixing the running total direction.

🧠 Conceptual

expert

Explain the Difference Between Compute Using Table Across and Pane Across

Which statement best describes the difference between Compute Using: Table Across and Pane Across in Tableau?

A Table Across and Pane Across compute identically but differ in performance

B Table Across computes vertically across rows; Pane Across computes vertically within panes

C Table Across computes only within panes horizontally; Pane Across computes across the entire table

D Table Across computes across the entire table ignoring panes; Pane Across computes only within each pane horizontally

💡 Hint

Think about the scope of computation across panes versus the whole table.

Table Across computes across all columns ignoring pane boundaries, while Pane Across limits computation to columns within each pane.