Query Please help

[#1]

Hi All,

I want to calculate like below

Year               Month               Average Salary         Previous Salary + Average Salary

2010                Jan                   15000                        15000

2010                Feb                   20000                        35000

2010                March               16000                         36000

like this

I reached till average salary ......but what function i should  have to used for Previous + average ....I am calculating this in chart Expression I used Last() function as well .....but did not work..

Help in this regards

Sarfaraz Sheikh

[#2]

Thank you so much..

I was also close to solution but I was not aware that label name can be used inside expression.

Thanks Anbu

[anbu1984]

You can use label name or Column(ColumnNo) --Here Column(2)