Making Pie chart for current and last year

[#1]

Hello Friends,

I have to put a pie chart for current year and last year, in the dimention I have used the Mode of Transport and the meassure is weight.

Could you please help on this...

Regards

Chriss

[Anonymous · Accepted solution]

Sum({$<Year={$(=Year(Today()))}>} Weight)

and

Sum({$<Year={$(=Year(Today())-1)}>} Weight)

Assuming that the expression is normally Sum(Weight)

[jagan]

Hi,

Try this

=Sum({<Year={'>=$(=(Max(Year) - 1))<=$(=Max(Year))'}>} Weight)

Hope this helps you.

Regards,

Jagan.

[#4]

Thanks a lot both Johannes and Jean Mohan.. it works fine.

Regards

Chriss