Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
then use Alternate states. Assign a different alternate state to all those 18 list boxes.
or assign a different alternate to the 2 list boxes and make sure your chart has "that" alternate state as well.
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