need help

[#1]

Hi All,

Please help me achieve below requirement in a QV Straight/Pivot table

ID	Number of Meetings Occured	Meetings	Reasons
1	2	7/10/2013	Discussions
		10/11/2013	additional details
2	4	24/6/2014	Missing Key Attendees
		6/8/2014	Not enough details
		26/6/2014	N/A
		25/5/2014	Meeting cancelled

Requirement is to create a table having ID, #Meetings occured, and to get the latest meeting for each ID and the Corresponding Reason for it.

For example

my table should look like below

ID	Number of Meetings Occured	Meetings	Reasons
1	2	10/11/2013	Additional details
2	4	6/8/2014	Not enough details

Please help.

any suggestions appreciated.

Thanks & regards

Jyothi

[IAMDV]

Cheers! Glad it worked. I solved many business problems using FirstSortedValue().