I need a way to rank by Date oldest to newest using Customer Number as the grouping. This calculated field formula ranked newest to oldest:
= RANKX(FILTER ('BR Residential',[CustID] = EARLIER ([CustID])), [TicketCompleteDate])
Starting data:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
End result:
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks in advance.
MacFletch
= RANKX(FILTER ('BR Residential',[CustID] = EARLIER ([CustID])), [TicketCompleteDate])
Starting data:
Customer Number | Ticket | Date | ||
106098188 | 17675888 | 1/2/2014 | ||
105037655 | 17677958 | 1/3/2014 | ||
105871234 | 17688841 | 1/8/2014 | ||
105037655 | 17702622 | 1/15/2014 | ||
106163379 | 17704680 | 1/17/2014 | ||
106098188 | 17721621 | 1/30/2014 | ||
105871234 | 17724629 | 1/30/2014 | ||
105037655 | 17752598 | 2/18/2014 | ||
105037655 | 17766808 | 3/4/2014 | ||
105871234 | 17797369 | 3/26/2014 | ||
105871234 | 17856817 | 5/3/2014 | ||
106163379 | 17881844 | 5/23/2014 | ||
105037655 | 18000989 | 8/20/2014 | ||
106098188 | 18017672 | 9/2/2014 | ||
106163379 | 18030032 | 9/11/2014 | ||
106163379 | 18061858 | 10/6/2014 | ||
106098188 | 18132493 | 11/29/2014 | ||
105871234 | 18194426 | 1/9/2015 | ||
106098188 | 18205779 | 1/17/2015 | ||
106163379 | 18267016 | 3/3/2015 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
End result:
Customer Number | Ticket | Date | Order | |||
105037655 | 17677958 | 1/3/2014 | 1 | |||
105037655 | 17702622 | 1/15/2014 | 2 | |||
105037655 | 17752598 | 2/18/2014 | 3 | |||
105037655 | 17766808 | 3/4/2014 | 4 | |||
105037655 | 18000989 | 8/20/2014 | 5 | |||
105871234 | 17688841 | 1/8/2014 | 1 | |||
105871234 | 17724629 | 1/30/2014 | 2 | |||
105871234 | 17797369 | 3/26/2014 | 3 | |||
105871234 | 17856817 | 5/3/2014 | 4 | |||
105871234 | 18194426 | 1/9/2015 | 5 | |||
106098188 | 17675888 | 1/2/2014 | 1 | |||
106098188 | 17721621 | 1/30/2014 | 2 | |||
106098188 | 18017672 | 9/2/2014 | 3 | |||
106098188 | 18132493 | 11/29/2014 | 4 | |||
106098188 | 18205779 | 1/17/2015 | 5 | |||
106163379 | 17704680 | 1/17/2014 | 1 | |||
106163379 | 17881844 | 5/23/2014 | 2 | |||
106163379 | 18030032 | 9/11/2014 | 3 | |||
106163379 | 18061858 | 10/6/2014 | 4 | |||
106163379 | 18267016 | 3/3/2015 | 5 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks in advance.
MacFletch