Skip to Content
0

How do I find the last 3 records of a group?

Aug 09, 2017 at 02:13 PM

27

avatar image

I'm trying to find the last three records of each group (some groups will have 1 or 2 records only)

How do I do that?

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Aug 09, 2017 at 04:29 PM
0

Hi Kurt,

1. Create a formula called @Selection with this code:

shared numbervar x := x + 1; 
COUNT({Any field on Details Section},{Field used as the Group}) - x;

2. Create a reset formula called @reset with this code and place this on the Group Header:

shared numbervar x := 0;

3. Go to the Section Expert > Highlight the Details Section (assuming that's where you've placed the records on) > Click the formula button beside Suppress and use this code:

{@Selection} > 2


-Abhilash

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks! Do you know if it's possible to filter based on the results to see only trends.

In others words if all I'm interested in is to see whether something has happened three times.

What I would have is

Client 1

Date 1 A

Date 2 A

Date 3 C

Client 2

Date 1 C

Date 2 C

Date 3 A

Client 3

Date 1 A

Date 2 A

Date 3 A

But all I would see is

Client 3

Date 1 A

Date 2 A

Date 3 A

Because all I care about is if A happened 3 times in a row (over the last three occurances)

0