Pivot Table - Need 2 set of data in the value section (Max & Value)

[Bonny]

Hi,

I need to a create a pivot, where I have Planned dates for different activities per country. Now, my leads requirement is to track progress as per the 1st planned date of each Country (regardless of the activity) and display a RAG.

I have created a pivot which displays the min date of each country; however, I am unable to pull the adjacent value of the same row in the pivot.

I cannot add an attachment as I don't see a way how I can.