Translating to set analysis

[liam_hanninen]

If I want to only see sales from Canada I would do this in set analysis:

sum({<Country={'Canada'}>} Sales)

similarly (but not ideally) I could do;

if (Country='Canada', Sales)

Now if I only want to see sales from this last year (YTD) I might do:

if( min(%Date)>(today()-365), Sales)

What is the set analysis equivalent of this?

[sunny_talwar · Accepted solution]

May be something like this:

Sum({<%Date={"$(='>=' & Date(Today() - 365, 'DateFieldFormatHere'))"}>} Sales)

Also look here:

Dates in Set Analysis

[liam_hanninen]

Yes great, thanks. And thanks for the link.

[maxgro]

sum({$ <Date={">=$(=AddYears(Today(),-1))<=$(=Today())"}>} Sales)