I have a table which has various info sorted by dates. What I'd like to be able to do is select the data in Column D based on the oldest or newest date in Column A.
Data:
| Column A | Column B | Column C | Column D |
| | | | |
| 01/01/21 | 1 | 22 | 45 |
| 01/02/21 | 78 | 12 | 62 |
My current set up on my report is a table which returns the cumulative of Column C over a month. What I'd like to be able to do is next to the cumulative value put the oldest item from Column D and then the newest item Column D, but I can't see a way of doing this. I have a slicer that will adjust the months.
Report:
| Name | Oldest | Cumulative | Youngest |
| Oranges | 45 | 107 | 62 |
