Getting the max date values in chart

[#1]

Hello Everyone,

This may be simple but I'm having a problem:

I have a table like:

ID     DATE          CODE

1     07/21/2013     A1
1     07/21/2013     B1

1     -                      C1

1                           D1

2     07/25/2013     A1

2     07/28/2013     A2

2     07/28/2013     B1

3     08/01/2013     C1

So, I wanted to display chart based on max of date which should show results like:

ID     DATE     CODE

1     07/21/2013     A1

1     07/21/2013     B1

2     07/28/2013     A2

2     07/28/2013     A2

3     08/01/2013     C1

So, based on the latest date, the table should show the values for that specific ID and Code.

[JonnyPoole · Accepted solution]

You can do that. When you add an expression, create an IF statement like this.  If the row is not the maximum date for the ID, it will evaluate as null and be auto suppressed

if(  Date=max( total <ID> Date), <expression> ))

[#3]

Thanks Jonathan,
but seems like it is not working. Any other suggestions?

Thanks.

[gmoraleswit]

Jonathan's solution is correct, please check attached.

[JonnyPoole]

i used your data set and came up with this.  Let me know if there is a different data set that illustrates your 2nd issue and i'll fix it. thanks !

[#6]

Sorry guys,

Confusion on my part. You both are awesome! Thanks Jonathan and Gabriela.