set analysis for date

[#1]

Hi,

I am trying to make a table with data for the past 5 days. This is the expression I am using:

Sum( {$< EventDate = {'$(vMaxDate)'},Account= -{'500','400'} >} Revenues).

What is the correct way to write this expression so that I have vMaxDate-1, vMaxDate-2......vMaxDate-5 in the set analysis? I have tried having the "-number" in different places in the equation but I keep on getting 0. Help appreciated.

Cheers.

[#2]

few modifications and It worked. Thanks a bunch!!!!

[#3]

Bring in your Date field as a dimension then?

[#4]

No worries, glad it works