Did you come across a time when Tableau would not allow you to drag a calculation to the dimension field?  It may be frustrating when you want to apply them as the dimensions when you would like to create a group or a set to them. In this blog, I am going to explore 3 kinds of numeric calculations that can’t be the dimensions in Tableau.

3 calculations can’t be the dimensions in Tableau

  1. Exclude and Include LOD calculation:
  2. Table calculation:
  3. Basic aggregation calculation:

The way to fix this problem

Generally speaking, Tableau won’t allow you to use a calculation that will change base on the view. Next time when you come across that, use a Fixed calculation to fix it or try to avoid the aggregation.

Leona Lai
Author: Leona Lai