Last Modified Date: 10 Dec 2018
Environment
Tableau DesktopResolution
Use one of the following workarounds:- Remove aggregations from the calculated field. For more information about aggregations, see How to Create an Aggregate Calculation in Tableau Help.
- If you created this calculated field to bin data, follow the steps in Binned Data in Tableau Help instead of using a calculated field.
- Alternatively, a FIXED Level Of Detail expression can be used in the conditional statements of the calculated field instead of an aggregation. For example:
IF SUM([SALES]) < 100 THEN "Low" ELSE "High" END
IF { FIXED [Region] : SUM( [Sales] ) } < 100 THEN "Low" ELSE "High" END
- Alternatively, a FIXED Level Of Detail expression can be used in the conditional statements of the calculated field instead of an aggregation. For example:
- Perform the field calculation in the data source before you connect to the data source from Tableau Desktop.
Cause
If an aggregation is used in the calculated field, the measure cannot be converted to a dimension, because the results of the calculation are dynamic.
For example, the following calculation cannot be converted to a dimension:
SUM([Sales]) / SUM([Number of Records])
The following calculation can be converted to a dimension:
[Sales] / [Number of Records]
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials