Calculated dimension

[Anonymous]

I have a calculated dimension and I want to create a list to select the output value shown in the calculated dimension column. How can link these two?

To shwo it with an example:

Client   Evolution   Sales

A          Up               50

B          Up               604

C          Down          98

D          Up               856

E          Down          46

Up or Down is the calculated dimension. Now I want a list with Up and Down in order to filter the infomration shown in the table...

[lorenzoconforti]

You can create a list and select <Expression> as field; you can then insert the expression used for your calculated dimension. The fields listed will be the same as your calculated dimension and you'll be able to filter using them

[Anil_Babu_Samineni]

What if Evolution is your list box filter?

[lorenzoconforti]

It would work

Try it. If it doesn't work maybe post your application; it would be easier to help you

[Anonymous]

I've tried this, and the list box is filled up with the output, but when I select one of them, automatically all output is selected and the table is not filtered. I'll try to creat an example .qvw this weekend, although I'm afraid that what I want is to complicated.

Is there any easy way to create a list box with some options and then apply a programmed filter? It's all about a sales comparison (customers, articles) and I want to filter those who have increased, decresaed, new or lost sales. But it all depends on dimensions used etc. I've done anmd reached already a lot of my purposes, but the problem is, is that clicking the calculated dimension doesn't work. The .qvw is to big to attach...

[sunny_talwar]

Would you be able to share a sample to look at this?