Vallue Listbox 2 depends on Listbox 1, and in listbox 2 only one value maybe selected

[curiousfellow]

I want users to be able to select from listbox1 what dimensions should be displayed in Pivot table -----works

I want a second listbox with the values selected in listbox1----works

Only one value may be selected in listbox2---  works

However, when one value is selected iin listbox2 it is not possible to select multiple values in listbox1

Please see attached sample. How to change this.

The dimension in listbox2 should be used to calculate a Total, so the other dimensions can be used to calculate as a percentage of value listbox2

[rubenmarin]

Hi, if you have %key_code in both tables selections in listbox2 will filter selections in listbox1, and if listbox2 have only one possible value listbox1 will have only that posiible value.

You can remove %key_code to have both tables as islands, so selections in one listbox won't filter the other listbox.

[curiousfellow]

That's a pitty, listbox 2 should only display the valus selected in Listbox 1

[rubenmarin]

A workaround can be selecting values using triggers.

Sample attached, triggers are configured in document properties.