above function

[vanderson009]

Hi Team,

I have below data.

Test:

LOAD * inline [

Year ,Month ,Sales

2015 ,January, 10

2015, February,20

2015 ,March ,30

2014 ,January ,10

2014 ,February,20

2014 ,March ,30

2013 ,January ,10

2013 ,February ,20

2013 ,March,30

]

I am expecting output of

Thanks,

Villyee

[sunny_talwar · Accepted solution]

Try Above(TOTAL Sum(sales))

[vanderson009]

Thanks sunny it worked, but may i know How Total is working.

[sunny_talwar]

check here

Missing Manual - Above() and Below()