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

I filter the view down to a single state, and the percent-of-total number keeps dividing by that one state's total instead of the whole company's total.

IntermediateRead 4 minDoing: about 25 minutes6 steps

▶ Start

What you'll have at the end

A percent-of-total calculation that stays anchored to the whole company's total no matter which state or category gets filtered out.

Before you start

You need

A worksheet already showing category sales as a percent of total, built with the default Percent of Total table calculation, on a dashboard that also carries a dimension filter for state.

Not covered

Building the percent-of-total chart itself from a blank sheet, or deciding which categories belong on it in the first place.

Leans on

6 steps

Where to go next

Force the Top N filter to obey a context filter first

When a Top N filter needs a context filter to run first, promoting one there is the right move; this recipe only warns against that same setting for a percent-of-total field.

Checked 26 Aug 2026

Part of the Tableau cookbook