Rearranging the view flips a running total's direction halfway through the table

I swapped two dimensions to see the data differently, and my running total reset halfway down.

IntermediateRead 4 minDoing: about 20 minutes7 steps

What you'll have at the end

A running total or rank table calculation that keeps moving the right direction no matter which dimension it's addressing.

Before you start

You need

A Tableau worksheet with a crosstab built from two dimensions and a running total, or rank, table calculation already applied to a measure on it.

Not covered

A running total that needs to restart at a grouping nothing in the view expresses calls for a level of detail expression instead of a Compute Using fix.

Leans on

7 steps

Where to go next

Percent-of-total math breaks once a filter narrows the view, unless the LOD is FIXED

Your total needs to restart at a grouping the view doesn't show, not one it does: that's a level of detail expression's job, not a Compute Using setting.

Checked 26 Aug 2026

Part of the Tableau cookbook