Want to retrieve only latest month data in straight table

[#1]

Hello all,

I have 3 fields.

CLIENTS

MONTH

REVENUE

Not all clients have revenue in all months.

I'd like to show in a straight table, the REVENUE FOR THE LATEST MONTH.

suggestion?  I tried incorporating max(month) into set analysis but doesn't seem to be working.

Thanks in advance!

[swuehl]

You are using a straight table with dimension CLIENTS? Try using

=FirstSortedValue( REVENUE, -MONTH)

as expression, then.

[#3]

Very close, but this is pulling in the FIRST month's revenue.

Is there a way to pull in the LATEST month's revenue?

Thanks again!

[swuehl · Accepted solution]

Have you used FirstSortedValue with a negated MONTH as sort weight as shown above?

[#5]

I just now saw that and plugged in the negative month.  This worked perfectly.  Thank you so much for your help!!!