Detach a table from one list box selection among multiple list selection...

[jegadeesan]

Hi All,

I need to detach a table from one particular list box selection among multiple list box selections.... That table should not have any interaction when the user made any selection on the specific list box  and the same time the values of the table should remain constant for the selections made...

Any Idea?

Regards,

Jegadeesan G

[hector_munoz]

Hi Jegadeesan,

Use set analysis like this to exclude tha selection in [Excluded Field] field: Sum({<[Excluded Field]=>} Amount)

Regards,

H

[jegadeesan]

Hi Munoz,

Dimension of the table is Brand and the table should not interact for the specific list box dimension also brand... How to do this?

Regards,

Jegadeesan G

[HirisH_V7]

Hi,

use this

Sum({<ListBoxField=>}Sales)

like above,In your set expression mention your listbox. then it will restrict the selections for that particular table.

HTH,

Hirish

[hector_munoz]

Then: Sum({<Brand=>} Amount)

[jegadeesan]

Hi Munoz,

It doesn't works to my case.... am getting the value along with the dimension used in List box....

Regards,

Jegadeesan G

[jegadeesan]

Hi Harish,

It doesn't works to my case.... am getting the value along with the dimension used in List box....

Regards,

Jegadeesan G

[hector_munoz]

Could you attach a sample?

Regards,
H

[jegadeesan]

The given table should not interact to the rounded list box selections...There are some other object in this sheet for this selection...

[hector_munoz]

Hi Jegadeesan,

I think the problem could be that you are using in set analysis the name of the listbox object (i.e. "Brand") instead of the name of the field in the model (i.e. [Brand Description). You have to use the name of the field in set analysis.

Could you try it?

Regards,

H