Overall data using Filter

[mnvrma]

By default, its showing current year data. but if I want to select Current Year and Previous year, how to show current year and previous year data in that using filter pane?

[Anil_Babu_Samineni]

If i understand correctly, Add this as filter condition

If(Year>=Max(TOTAL Year, -1) and Year<=Max(TOTAL Year), Year) // This condition to give only 2 values to filter

If that is not expecting, Create bookmark for selections and then open the app It will point to the sheet where exact you have created bookmark and disaplys by default to select 2 values as per needs