Cummulative using Set Analysis

[#1]

Hi All,

I have a trend of sum(revenue) on monthly basis.. But now i need to make this trend as the cummulative Trend. ie the subsequent month will go on suming the revenue.. I d'nt want to use the Full accumlation function as available in the Property box.. Want to use it using set analysis or some other way..

Please try to help me..

Thanks in Advance..

Regards,

Ankit

[#2]

Plz any one can repy...

[pover]

Use the above() function.

above(sum(Sales)) + sum(Sales)

[#4]

Thanks Karl for the reply.. But is there any way we can use by Set Analysis alos?

Thanks,

Ankit

[pover]

Sadly, you cannot reference the dimension value of a chart in the set analysis of an expression. Go to this discussion http://community.qlik.com/forums/t/40894.aspx where John has uploaded an example that might be interesting to you.

Regards.