how to show a staright table expression in a list box

[#1]

Hi all,

I have a straight table with 4 expressions and 3 dimensions and one of the expression (variance) having positive and negative values ,

my requirements is I need to create a list box as filter its should show 'positive' n 'negative' if user selects negative, only negative values should display in straight table and vice versa..

Thanks in advance

santhosh

[avinashelite]

Hi Venkat,

Using expression, you cannot achieve this!!

[Anonymous]

what do u mean i have it working

[avinashelite]

Hi Farai,

Your solution work on dimension, but his requirement is different.

E.g

Data,Amont,Amont2

A,1000,2000

B,3000,2000

A,1000,3000

his chart looks like

Dimension,E1(Sum(Amont)), E2(Sum(Amont2)), E1-E2

A, 2000,5000, -3000

B,3000,2000, 1000

now he want the + and - sing of expression E1-E2 and then  when you select + and - this expression should show + and - values.

Hope now you got the issue. Its not possible to achieve on expression!!!!

Regards,

@vi

[Anonymous]

Hi avinash ,

Sorry i get you now,

thanx for the clarity