Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to set up a fairly complex listbox calculated expression but it does not seem to work.
i have 3 expressions in a pivot table
What i am trying to achieve is to make a listbox that contains as selections the result of the (2-1-3) expression
Is that even possible in the interface??
Regards
This should do the trick.
Hi You can add these Expressions into List Box Expression tab.
Please provide the qvw with scrambling the data.
Here is a sample app.
If someone could help I would be grateful.
Maybe like this?
Hi swuehl,
Thanks a lot for the try. But in your sample app what I am trying to select >=0 or <=0 on the list box I get positive and negative values as well which should not be the case.
My actual specification is to be able to select between positive and negative values.
If you can give it one more try I would appreciate it.
Kind Regards
This should do the trick.
That is superb....
You totally deserve the first place on the board