previous date

[Prithika]

i have attendance data of 4 dates

17/08/2023,

18/08/2023,

19/08/2023,

21/08/2023

i have to show presentees for previous date.

i using filter pane for this date.

if no selection are made maximum date's previous date presentees should be displayed.

if selection is made, the selected  date's  previous date presentees should be dispalyed.

for example:

if no selection is made , the maximum date is 21/08/2023 so it should show 19/08/2023 presentees.

if 18/08/2023 is selected it should show 17/08/2023 presentees.

is it possible? can someone help?