Showing negative values in Year over year by month

[berryandcherry6]

Hi all,

I want to show a line graph where it displays  Year over year by month  of  count of invitations.

I want to show graph for previous and current year.

I have tried with

Dimension : year and Month

Expression :

count({<DateType = {invitation},Year = {$(=max(Year))}>}invitation_id)-count({<DateType = {invitation},Year ={$(=max(Year)-1)}>}invitation_id)

I think there is wrong in my expression.So it is showing negative values  I have attached qvf file .

Please help me in this regard.Any kind of help is appreciated.

Regards.

[arulsettu]

after adding it click exploration icon

you will see the alternate expression click it

[berryandcherry6]

I can see alternate option, but the count datas dont get displayed in line Chart after adding expression in generated report.

This is used to view datas dynamically. If i have generated report it will be static right?