3 Replies Latest reply on May 24, 2017 2:34 PM by Srinidhi Narayan

    calculate variances  for month to previous year months without table calculations

    Indre White

      Hi, I am trying to compare year over year monthly data and display  bar charts with variances and %. I cannot use dual axis year to year comparison as it will be 4 or more years.

      I am comparing year over year changes using  lookup -    ZN([measure])-lookup(ZN([measure]),-1).

      How do I compare January 2014 with January 2015, February 2014 with February 2015 and so on.  then January 2015 with January 2016, Feb 2015 with Feb 2016? I need to display bar charts with variances and %

      I would not want to use table calculations and will need formula, appreciate your help. If anyone can guide me,

       

       

      thanks a lot