6 Replies Latest reply on Jul 18, 2018 7:03 AM by Reporting DAD

    How to add the percentage difference in rows for 2 weeks from 2 years

    Reporting DAD

      Can we get a row for % difference between 2 rows similar to a row of Grand Totals.

       

      I want something like this, where I can get the %Change Generic and %Change Manufacturer for the same week of two years.

       

            

      Year of DateWeek of DateNameCategoryRevenueSpend
      2017Week 25BrandGeneric420.0496.0
      Manufacturer360.0411.0
      2018Week 25BrandGeneric215.0306.0
      Manufacturer400.0441.0
      %Change Generic-48.81-38.31
      %Change Manufacturer11.117.30

       

      I have attached the workbook with data.