All tagged LOD

Tableau FIXED LODs Not Filtering (Dimension and Context Filters)

Ollie Linley
Level of Detail

FIXED LODs are wonderful because they allow us to aggregate our measures at a chosen Dimension level, regardless of the level of detail of the worksheet. However, they aren't affected by Dimension Filters, because they're calculated before Dimension Filters are processed.

There are various scenarios where we need to work around that. We'll use Context Filters to help us where we need our LODs to be filtered, and we'll take a look at an example where you might not want your LOD to be filtered by your Dimension Filters.

Computing Header Totals in Tableau

Kirk Olson
Tableau How-Tos

I recently got an email from a former student explaining that they were trying to recreate something similar to the image below in Tableau.

The trouble she was running into was recreating the total header called “Planned Cost by Perf”. If you try to use a measure as a discrete header, you end up with the value summed for each partition. Here is an example using Superstore data: