Set analysis alternate states

[#1]

I am not getting Set analysis alternate states scenario .. Somebody please tell me about Set analysis alternate states scenario please send me step by step procedure for Set analysis alternate states send me sample data also

Thank you...:-)

[sunny_talwar]

Attaching a sample with Alternate State and Without Alternate State:

Regular Expression:

=Sum({<WeekYear = {"=Num(Only({<WeekYear = >}WeekYear)) >= Max(TOTAL WeekYear) - 11 and

  Num(Only({<WeekYear = >}WeekYear)) <= Max(TOTAL WeekYear)"},

Date = , Week, Year = , Month = , Day = , MonthYear = , Quarter =>} Value)

AS Exp: Name of the alternate state is AS

=Sum({AS<WeekYear = {"=Num(Only({AS<WeekYear = >}WeekYear)) >= Max({AS}TOTAL WeekYear) - 11 and

    Num(Only({AS<WeekYear = >}WeekYear)) <= Max({AS}TOTAL WeekYear)"},

Date = , Week, Year = , Month = , Day = , MonthYear = , Quarter =>} Value)

First expression will driven by WeekYear list box and Second expression will be driven by WeekYear AS (this list box is in the alternate state)

HTH

Best,

Sunny

[#3]

thank you

[ecolomer]

See this example:

[ecolomer]

And this

[#6]

i did not get any scenario please verify and attach again scenario send me