Calculating Percent of Total for Aggregations by a Dimension Across that Dimension. Use the function SIZE to differentiate between different parts of the view in a calculation. Environment Tableau Desktop Answer.
SUM Sales TOTAL SUM Sales.
In this video we have to walk through how to create a percentage in Tableau and how to aggregate it correctly to make sure you always get the correct result. The grand totals for rows show that 2014 accounts for 3195 of the total sales. In this silent video youll learn how to customize the Grand Total or Subtotals to show a different value than the main table of the view. How to display the value subtotal and grand total for different levels of granularity in the same view.