KNOWLEDGE BASE

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


Published: 05 Aug 2016
Last Modified Date: 15 Mar 2017

Question

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.

Environment

Tableau Desktop

Answer

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?