Resolving an incorrect Total value in a pivot table
Written by
Updated at December 17, 2025
Issue description
Once added to the pivot table, the Total field values are displayed incorrectly.
Solution
In pivot tables, row values are calculated using the same formulas as the measure aggregation. However, the totals row does not display results calculated with LOD expressions, window functions, and time series functions.
For more details, see this guide.
If the issue persists
If the above actions did not help, create a support ticket