Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=FirstSortedValue([Assigned to], -Aggr(Max([Start date of ticket]),[Business Owner])
=FirstSortedValue([Assigned to], -Aggr(Max([Start date of ticket]),[Business Owner])
It worked !
Thanks Manish.