Facing issue with Alternate states and Set Analysis

[Anonymous]

Hi the set analysis expression is working fine with the default state but it’s giving unexpected results with Alternate states

I have Alternate State of “Group1”how to incorporate the Alternate state to the below expression. Thanks

=Num((sum({1<[ Year]=P({$}[Year]),Product={'Shippers'}>}[Gross Sale])/
sum({1<[ Year]=P({$}[Year]), Product={ Shippers'}>}[Gross Revenue])-1),'#.# %')

[sunny_talwar]

You want this expression to be driven just by the alternate state only? Try this:

=Num((sum({[Group1]<[ Year]=P({[Group1]}[Year]),Product={'Shippers'}>}[Gross Sale])/
sum({[Group1]<[ Year]=P({[Group1]}[Year]), Product={ Shippers'}>}[Gross Revenue])-1),'#.# %')

[Anonymous]

Thanks for Quick Response.I'm expecting the :"1" to take the set as complete selections not current selections.

Num((sum({

1

<[ Year]=P({$}[Year])

[sunny_talwar]

May be this:

=Num((sum({1<[ Year]=P({[Group1]}[Year]),Product={'Shippers'}>}[Gross Sale])/
sum({1<[ Year]=P({[Group1]}[Year]), Product={ Shippers'}>}[Gross Revenue])-1),'#.# %')

[Anonymous]

Thanks it works