11 Replies Latest reply on Feb 10, 2017 2:24 PM by Peter Galimutti

    Category Sales Growth - Calculation in Tableau

    Dan Hunnewell



      I am having difficulty figuring out the calculation needed to find "% contributed towards category growth".


      Below is a snapshot of what I am trying to find: The last column in red are the figures that I cannot recreate in Tableau.


      Categories2016 Sales2017 salesDifference in sales% Contributed to Growth
      Cat 1




      Cat 21018829%
      Cat 310201036%
      Cat 41015518%
      Grand Total406828100%


      I am having difficulty getting to the sales difference by category as a percent of the sales difference of the total category.


      I think this may require an LOD expression but I am uncertain.


      Thanks much,