Hi,
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.
Data
Sales : Date
10, 13/06/2022
5,13/06/2023
In table
Date1 Sales : Date2 Sales
10, 5
Thanks
