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
      2018Week 25BrandGeneric215.0306.0
      %Change Generic-48.81-38.31
      %Change Manufacturer11.117.30


      I have attached the workbook with data.