Display cummulative value

[#1]

Hi Everyone,

I would like to display the sum of all values upto current month in data points upon mouse over. For example, if i have a chart with month names in dimension and some value being used in expression, if i hover over the May month's value, it should show the sum of all values starting from Jan to May in tool tip( as data points). Is it possible?

Please advice.

Thanks,

Senthil.

[sundarakumar]

PFA

[sundarakumar · Accepted solution]

U  can have it as a different field for pop up, or u can use dual for the same purpose, like in the attachment.

dual(sum(stock)&chr(10)&'Accumulated = '&rangesum(above(sum(stock),0,rowno())),sum(stock))

[#4]

Hey Sundarakumar,

Thank you for your quick response. It seems to be working great