Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an app with several sheets.
Now I have to add one sheet based on the selections of the default state, but with one extra selection in a listbox.
I thought I could solve this by adding an alternate state and set the new listbox and a chart to that new alternate state.
However I cannot find any documention how to make an expression that includes the selection of the default state and the selection of the alternate listbox added to that. (or I just don't get it)
Someone knows where to find a good example or some documentation ?
Johan Kruize wrote:
Now I have to add one sheet based on the selections of the default state, but with one extra selection in a listbox.
Not sure if I completely follow... do you mind expanding a little?
I added a sheet using the same data as in the other sheet.
In the added sheet a month has to be selected. All other sheets have a listbox in which one or more years have to be selected.
So when I add the "month"-listbox as usual, all results in the other sheets change to, while they should not.
Seems that I soved this bij using [state1 * $]