Set analysis previous selection in alternate state.

[marunio007]

Hello,

I am successfully using expression=Count({$1-$}1) to list records that were dropped after last selection in straight table chart.

I am having trouble to implement this in an alternate state.

My alternate state is named MF.

I tried:

=Count({$1-MF}1)

=Count({MF1-MF}1)

=Count({MF$1-MF}1)

none of which seem to work.

Has anyone tackled similar issue?

Kind regards,

Marek

[trdandamudi]

May be like below:

=Count({$1-$::MF}1)

[ramasaisaksoft]

check like this

Count ({[MF]<$1-$>}1)

ex:-

the SUM of Sales for the previous year in a straight table. The straight table has the alternate state "Group 3", thus I formulated the expression as follows:

Sum( {[Group 3]<Year = {  $(=max(Year)-1)}>} Sales )

[marunio007]

Thank you for both attempts but your suggested solutions do not work.

I guess my post is more about a general question: is there a reference to a previous selection in an alternate state ? If yes, what is the syntax?

[Anonymous]

Not sure if you got the answer but MF::$1 will give you the previous selections in MF alternate state