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

    Category Sales Growth - Calculation in Tableau

    Dan Hunnewell

      Hello,

       

      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

      10

      15

      5

      18%
      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,

      Dan