How to select the latest value for a given set of values

[deepti_singh]

Hi,

     I have a pivot table as below.

Table 1     

Business Owner     Tickets     Assigned to     Start date of ticket    

                                   N12          Mark               12/12/2012

Bob                            N13          Mathew           01/01/2015

John                         A 70          Hanna              12/16/2013

The requirement is to create a new column which displays the name of the assigned ticket according to the most recent "start date of ticket". For example the new column would have

Table 1     

Business Owner     Tickets     Assigned to     Start date of ticket     Latest assigned to

                                   N12          Mark               12/12/2012                Mathew         

Bob                            N13          Mathew           01/01/2015

John                         A 70          Hanna              12/16/2013                   Hanna             

Thanks.

Regards,

Deepti

[MK_QSL · Accepted solution]

=FirstSortedValue([Assigned to], -Aggr(Max([Start date of ticket]),[Business Owner])

[deepti_singh]

It worked !

Thanks Manish.