I would like to sum revenue only for the last date in the database. This is what I tried but with no luck:
IF [Date] = MAX([Date])
I want to show aggregate revenue (which is already done), directly next to today's revenue.
Thanks for your help!
Retrieving data ...