Extract Data from column based on oldest/newest date
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.
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.