I got two date fields in the same data set, one called date1 and the other called date2.
I got two date pickers (can have one if possible) one for date1 and the other for date 2.
In a table, I want to calculate the sales for date1 and date2 in the same table. When I pick one or the other now, they are over ridding each other. for example I want 13/06/2022 to say 10 and 13/06/2023 to say 5.