This Year vs Previous Year

[soha1902]

I have Year and Sales data.

Now I want if user select any year then table will show selected year and previous year sales.

Please help me. Sample app attached.

[VishalWaghole]

Hi Soha,

PFA Hope this will solve your issue.

Current Year = sum({<Year= {'$(=Max(Year))'}>} Sales2)

Previous Year = sum({<Year= {'$(=Max(Year)-1)'}>} Sales2)

-- Regards,

Vishal Waghole

[er_mohit]

Hi

Go here Current Period and Last year Same Period

Hope it helps you