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

Published: 08 Feb 2016
Last Modified Date: 14 Aug 2017


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 up to 9.2


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

Do not use an LoD and instaed use the Advanced Partitioning/Addressing of a table calculation to control how the SUM() is computed.


At this time, LoD expressions cannot be used inside table calculations.
Did this article resolve the issue?