Set Analysis

[#1]

Hi,

Can somebody help me with this set analysis expression?

=sum({<[Transaction Code]={'959','654','661','660','659','658','657','655','664','653',

                           '652','651','650','656','662','663','851','852','853','854',

                           '855','856','857','858','859','860','861','862'},

        [Transaction Run Month Year]={'Mar 2015'}>}[Transaction Amount])

Instead of hard coding "Mar 2015", I want the expression to automatically take Transaction Run Month Year -1.

Thank you in advance.

Regards,

Adi

[MK_QSL]

{"$(=Date(MonthStart(Today(),-1),'MMM-YYYY'))"}

[#3]

Hi ,

Create a variable let vMaxMinus1Year= AddYears(Max(Transaction Date()),-1);

Then use the above variable in set analysis

sum({<[Transaction Code]={'959','654','661','660','659','658','657','655','664','653',

                           '652','651','650','656','662','663','851','852','853','854',

                           '855','856','857','858','859','860','861','862'},

        [Transaction Run Month Year]={'$(vMaxMinus1Yea)'}>}[Transaction Amount])

Thanks,

shekar.

[#4]

It's not working Manish.

[#5]

Its not working, Shekar!!!

[Anonymous]

Remove "-" from the Manish's solution:

... [Transaction Run Month Year]={"$(=Date(MonthStart(Today(),-1),'MMM YYYY'))"} ...

[#7]

Thank you Michael, it worked.

[Anonymous]

I think Manish deserves the "correct" points.

[#9]

Thank u Manish!!