Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
expression :-
=Num( sum({$<Sold_year ={"$(=max(Sold_year)-1)"},season={$(vSales_Summary_Previous_Season)}>} [inv value]/Sales_INR_Unit ), '#,##0.0')
Previous_season variable:-
vSales_Summary_Previous_Season
=season (field name)
Current_season_variable:-
vSales_Summary_Previous_Season
Image isn't opening, but what exactly is the issue?
i want to show the comparison of sales on basis of season code ie if I select 17A it should reflect in current season and if i select 16A it should reflect under previous year.