Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jegadeesan
Creator
Creator

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

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

12 Replies
hector_munoz
Specialist
Specialist

Hi Jegadeesan,

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

Regards,

H

jegadeesan
Creator
Creator
Author

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
Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”
hector_munoz
Specialist
Specialist

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

jegadeesan
Creator
Creator
Author

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
Creator
Creator
Author

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
Specialist
Specialist

Could you attach a sample?

Regards,
H

jegadeesan
Creator
Creator
Author

Atlernate.PNG

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
Specialist
Specialist

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