nth Order tool

rmwillis1973

Hi,

Just a quickie - how do i create a field which calculates the nth Order (1st, 2nd, 3rd etc) for a particular customer.

I have Customer No, Order Date & Order No. fields in my data.

i'm sure it is very easy, but can't find a solution on the forum.

Thanks,

Richard

michael_treadwell

Use the Multi-Row Formula tool to create grouped counts

nthorder.yxmd