Create dynamic table based on value selected in a listbox
Hello,
I have the the following table loaded (refer code below).
Data: LOAD * INLINE[ BookedCountry, ManagedCountry, Revenue France, France, 100 France, Canada, 150 France, Brazil, 80 Germany, Canada, 180 Germany, India, 220 ];
I have a listbox for [BookedCountry]. I want to use a script to create a table which will use the table Data as resident table with the where value will be the value I select in the listbox [BookedCountry].