Display data based on the maximum date

building reports webintelligence
1

I have data in the below format:

Name, appointment date, Height, Weight, BMI
Name1, 1/1/2008, 65 in, 163 lbs, 27
Name1, 2/1/2008, 66 in, 165 lbs 27.1
Name1, 3/1/2008, 67 in, 167 lbs 27.4
Name2, 3/1/2008, 60 in, 160 lbs 26.4

I want to get the maximum appointment date and the height, weight and BMI for that maximum appointment date.

I tried using the break and fold option that does not work. Any suggestions would be great.

Jony (BOB member since 2004-07-09)

2

Try this:

:arrow_forward: Create a Variable: Max Date: =Max([appointment date])In ([Name])
:arrow_forward: Create a Variable: Max Flag: =If([appointment date]=[Max Date];1;0)
:arrow_forward: Put a filter on the table where Max Flag = 1

I tried it with you sample data, and it worked.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Got it! It worked perfectly Micheal! Thanks!

Jony (BOB member since 2004-07-09)