4 Replies Latest reply on Sep 21, 2019 10:55 AM by kshitij.kohli

    Show Percentage difference for filtered Data

    kshitij.kohli

      Hi, I have a date field that has 4 years of data say 2015 to 2019. I want to show % difference on products say Furniture, Medicine etc.

      When I apply filter on dashboard for only 2018 the data goes blank as it cannot calculate % difference from previous year. But since the data for 2017 is still available it should show value.

      I have 3 separate filters Year , Quarter and Month.

       

      Sample data

       

      YearMonthCategorySale Amount
      Qty

      2017

      JanFurniture102
      2017FebFurniture204
      2017MarFurniture305
      2018JanMedicine401
      2018FebMedicine504
      2018MarMedicine608