2 Replies Latest reply: Mar 30, 2017 4:01 AM by Karol Bruski RSS

    How to create comparison between neighboring data on graph?

    Karol Bruski

      Hi!

       

      I have trouble, which bother me for long time. I want compare two neighboring data on graph, which show sum of sale in given periods. I am using formula (sum of sale is my variable) =sum(sum of sale) / above(sum(sum of sale),rowno()-1), which works, but no in way I want - it compare every data to first value, not to nieghboring. I want to have different effect - the second value to first, the third to second etc. And it must be universal, because i want to filter months, according to my needs in some point of analysis. Can you help me? I'll be grateful.