I have a data source with date/time and different values.
An example of the data I have is the following:
3/3/2019 11:15 | 23.3
3/3/2019 11:30 | 23.5
3/3/2019 11:45 | 24.5
The pivot table I already created for the different days has the maximum value for 3/3/2019 (let's say it was 24.5).
How would I be able to retrieve the date associated with the maximum value (in the example, I would like the value "3/3/2019 11:45").
FYI, I also have multiple columns with similar information in which I which the data retrieval needs to work as well, not just 1 column worth of data.
Thanks for your help