Data Viz Done Right

April 5, 2016

Tableau Tip Tuesday: Compare One Dimension Member to All Others With LOD Calcs


This week’s Tableau Tip Tuesday continues the series on LOD expressions. This week I show you how to compare one member of a dimension to all others in the same dimension. For example, you might want to see how the profitability of Binders is doing compared to all of your other product sub-categories.

If there are other videos you’d like to see, please leave a comment. I’m always looking for new ideas.


  1. Really enjoying the series on Level of Detail expressions -- this here is a great real-life use case!

    I'd be interested to see if you come upon any strange cases when using this type of LoD techniques ("select one value of a dimension") on a viz which uses both Grand Total feature and Show Filters on a component dimension... I've come upon some head-scratchers trying to get that sort of thing to work.

  2. Great tip, thanks for sharing!