Avoidance in list box

[Anonymous]

Hi All

In list box, how it is possible ignore selection.

Like in below Set Analysis SNAME slection are ignored.

sum({$<SNAME=>} VALUE)

Is this possible in list box? Like show all SNAME

Thanks

[petter]

Create an "Alternate State" in your Document and then select the newly created alternate state as the state for your list box. Then this list box will not be selection-wise be connected to your default selection state.

[Anonymous]

Hi Petter

By this even if I select any SNAME which does not affect to my Pivot table.

I should need this effect based on SNAME selection

Thanks for your suggestion

[petter]

Then you can refer explicitly to the selection in the Alternate State like this:

     Sum( {AltState1} Sales)

This makes the Sales be affected by only AltState1 but you can refine it with set modifiers or even combine it with selection in the default state which has the name $ ... just as the default selection also has the name $:

    Sales( {AltState1<SNAME={'ABC'}>} Sales)

Or

   Sales( {AltState1<SNAME={'ABC'}*$<Product={'B123'}>} Sales)

This will intersect with the * between the rows in AltState1 and Default State taking into account the modifiers too.