6 Replies Latest reply: Dec 7, 2017 1:24 AM by Abbas Alrebh RSS

    How can I add a percentage of sales growth - Pivot table.

    Abbas Alrebh

      Hi everyone,

       

      I want to add a percentage of sales growth from year 1 to year 2 for each category.

      Screen Shot 2017-12-06 at 11.44.33 PM.png

      It should be something like this:

      Screen Shot 2017-12-07 at 12.50.18 AM.png


      The formula

      % increase = ((Sales year 2 - Sales year 1) ÷ Sales year 1) X 100