I have 3 fields.
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!
You are using a straight table with dimension CLIENTS? Try using
=FirstSortedValue( REVENUE, -MONTH)
as expression, then.
Very close, but this is pulling in the FIRST month's revenue.
Is there a way to pull in the LATEST month's revenue?
Have you used FirstSortedValue with a negated MONTH as sort weight as shown above?
I just now saw that and plugged in the negative month. This worked perfectly. Thank you so much for your help!!!
Retrieving data ...