Marking top 12 records by Account

[paulm]

Hi,

I am trying to flag up the 12 most recent records for each account in our  data set. 

The data at the minute is:

Account, Transaction ID, Transaction Date

1          ,  123               , 18/05/2012

1          , 124                , 18/06/2012

2          ,  321              , 18/05/2012

2           , 322                , 18/06/2012

etc....

I can find the top record in each with 'peek' but not sure how to expand this out to the top 12 records. 

Thanks in advance.

Paul

[jagan · Accepted solution]

Hi Paul,

Please check file attached.  Hope it helps you.

Regards,

jagan.

[paulm]

Hi Jagan,

That worked perfectly! Nice bit of logic!

Thanks

Paul

[jagan]

Hi Paul,

Can you close this post by clicking Correct Answer button to my post, if it solves your problem.  So that it would be helpful for others to find solution for similar type of problems.

Regards,

Jagan.