Why This set analysis not work?

[Anonymous]

Hi all,

I post the sample where my set analysis not work ..

Thank to all

Andrea

[#2]

Set analysis may not work > operataors when you use the format option. Attached one of the ways to solved the your problem.

Hope it helps,

Kiran.

[IAMDV · Accepted solution]

Hi Andrea,

Have you tried to use this expression?

Sum({<YearMonth = {">=$(=Date(addmonths(Max(YearMonth), -12), 'MMM YY')) <=$(=Date(addmonths(Max(YearMonth), 0),  'MMM YY'))"} >} Sales)

I guess its the formating issue. I hope this helps!

Cheers - DV

[Anonymous]

Thank Kiran for your answer

unfortunately is not wath i want because if u select a month i can not see 12 month before.

Thank

[#5]

You this expression:

Sum({<YearMonthID ={">$(=Max(YearMonthID)-12)"},YearMonthName= >} Sales)

kiran

[#6]

You this expression:

Sum({<YearMonthID ={">$(=Max(YearMonthID)-12)"},YearMonthName= >} Sales)

kiran

[Anonymous]

Ciao DV,

thank u are right now it works...

Thank very much

Andrea

[SunilChauhan]

see the attached file and put your data and change thee dimension andd expression accordingly

hope this helps

[Anonymous]

Thank kiran , try wath DV send me is that wath i wanted.

Thank for your help

Andrea

[Anonymous]

Thank Sunil   your attch is very helpfull