Create a listbox with several variables

[pauldamen]

Dear all,

I want to create a listbox containing different variables I made which you can select.

So I have 5 variables created (5 formulas) which I  want to put in a listbox so that users can select 1 which is then put into a graph.

How can I put the 5 variables in 1 listbox? I can't make a group because it is nog cyclic or drill down, I want to display the five variables just in a row.

How someone can help me!

Kind regards,

Paul

[Gysbert_Wassenaar]

$(=Variable)

Mind the capital V and make sure to include the = sign

[pauldamen]

Sorry but I am not a idiot.

As you can see I have done this in my test file (other then the different field name), but it is not working because it turns it into a variable!

And you can also see that the table stays empty and doens't look like the below table which it should

[whiteline · Accepted solution]

Hi.

Everything works fine in both versions.

You use alternative state so the selection you've made in listbox with formulas does'nt affect the pivot.

And remove '=' sign in front of your stored expressions.

[pauldamen]

Hi,

It works great!

Just one more question, how can I link this inline to the rest of my data? Because when the variable is in the graph I also want to slice through it with selections.

But at the moment the inline is not linked to the rest of my data

Regards,

Paul

[whiteline]

the inline is not linked to the rest of my data

Don't understand your problem.

It's not nesessary, you can slice your data as before.