Restrict field selections on charts

[bhaskarsharma03]

Hi,

Can anyone suggest how can I make my chart react to field selections only on some predefined fields? It shouldn't be changed by selections on other fields.

For example, I have some 20 dimensions available for users to select from, but I want my chart to respond to only 2 of the dimensions, for rest of the dimensions it shouldn't respond.

Please refer to the attached sample application.

Regards,

BS

[#2]

then use Alternate states. Assign a different alternate state to all those 18 list boxes.

[#3]

or assign a different alternate to the 2 list boxes and make sure your chart has "that" alternate state as well.

[aveeeeeee7en]

Hi Bhaskar

Try this in your expression:

sum({<$(=concat({1<$Field-={'Country','ID'}>} '[' & $Field & ']=',','))>} Amount)

The fields used in the expression will give you the result on their Selections. Rest all other fields are excluded.

Hope that works for you.

See the Attachment.

Regards

Aviral