Unable to Use a Table Calculation such as RANK() on An LOD (Level of Detail) Calculation

Published: 08 Feb 2016
Last Modified Date: 13 Jun 2020


When using RANK() on an LOD calculation, the following error might occur: 
All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources.


Tableau Desktop


Option 1

Apply aggregation to the LOD such as RANK(SUM([LoD])). Note, this will aggregate the LoD up to the level of detail of the view.

Option 2

Use the Advanced Partitioning/Addressing of a table calculation to control how the SUM() is computed, instead of using an LOD.


LOD expressions are row level expressions. Like all other row level expressions, they must be aggregated when used in table calculations.
Did this article resolve the issue?