Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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