Include just first 2 sessions per person 1

[kernal]

csv file:

person_id session start_date

1 1108-1 08/17/2010
1 1108-2 10/19/2010
1 1111-1 09/20/2011
1 1111-2 10/01/2011

2 1104-2 01/10/2010
2 1112-1 05/15/2012
2 1112-2 09/15/2012

I just want to include the 1st 2 sessions per person_id so only:

person_id session start_date

1 1108-1 08/17/2010
1 1108-2 10/19/2010

2 1104-2 01/10/2010
2 1112-1 05/15/2012

Any help is appreciated. Thank you

 

[hilfy]

You could try this:

Create a running total that will count the number of sessions and reset when person_id changes. Then go to the Section Expert and set the suppression formula to suppress the section where this data is displayed when the value of the running total is greater than 2.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[kernal]

Thanks hilfy. It worked great.