5 Replies Latest reply on Jun 19, 2018 1:23 PM by Anil Kumar

    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.