Creating a "Percent Of Total" Calculated Field Without Using Table Calculations

Published: 05 Aug 2016
Last Modified Date: 09 May 2017


How to create a view that shows the percent of total, without using table calculations.
For example: when using table calculations in views that contain grand or subtotals, the grand/subtotals may show unexpected results with a table calculation in use.


Tableau Desktop


Instead of table calculations, or using the TOTAL() function, use Level of Detail (LOD) expressions such as:
{ FIXED [<dimension(s) you are looking for the percentage of total information for>] : SUM([Measure]) } /
{ FIXED [<"Total" dimension(s)>] : SUM([Measure]) }
Did this article resolve the issue?