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?
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
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
