4 Replies Latest reply on Nov 14, 2017 2:53 PM by laura.vanzutphen

    Difference between percent of total and previous percent of total

    laura.vanzutphen

      Hi all,

       

      In my workbook (see attached) I am calculating the percent of total across different types of products. So for every week, I can see how much of the sales can be attributed to product A, product B and product C.

      Now I want to compare this to the previous week, so that I am able to say: "product A consisted of 21% of total sales this week, it was 20% of sales last week, so the percentage increased with 1".

      However, if I define 'last week' as

      LOOKUP(SUM([Amount]),-1)/LOOKUP(TOTAL(SUM([Amount])),-1)

      then it needs Table (down) to calculate the correct percentage of product A, but it needs Table (across) to get the previous week. However, Tableau does not allow me to do this simultaneously.

       

      Am I doing something completely wrong? Or how can I achieve this?

       

      So just to be sure, I would like to achieve this:

      Week 1
      Week 2Week 3
      Type AThis week = 20%

      This week = 21%
      Last week = 20%
      Difference = +1%

      This week = 19%

      Last week = 21%

      Difference = -2%

      Type BThis week = 30%

      This week = 31%
      Last week = 30%
      Difference = +1%

      This week = 29%
      Last week = 31%
      Difference = -2%
      Type CThis week = 50%

      This week = 48%

      Last week = 50%

      Difference = -2%

      This week = 52%

      Last week = 48%

      Difference = +4%

       

      Thanks for your help!