1 2 Previous Next 17 Replies Latest reply on Feb 12, 2019 11:09 PM by amar savale

    Indicator based on previous month value

    koushik.neelakantha

      Hello everyone, Please find the attached workbook.

       

      I need to show Indicators(Red and green arrows) in the dashboard WRT last month sales.

       

      1) Red arrow: if current month sales < last month sales.

      2) Green arrow: if current month sales >= last month sales.

       

      above logic should be applicable WRT year and month. Suppose we have data till Jan 2019. sales value should be compared with Jan 2019 and Dec 2018.

       

      Need to place shapes as below:

       

       

      Regards,

      Koushik.Mahfooj Khan

      Zhouyi Zhang

        1 2 Previous Next