Display only selected value in staright table

[#1]

Hi,

I am stuck with a scenario where I need experts advice.

I have a table with two columns Type and Value.

Type columns has 3 values -"op", "non-op" and "ex op".

In a straight table I want to display sum of values based on each type.

My expression are

Op exp - Sum({<type={'op'}>}value)

Sum({<type={'non-op'}>}value)

Sum({<type={'ex op'}>}value)

Now I want that if I select 'op' in list box I should get its value and remaining columns should display 0.

Thanks

[sunny_talwar]

Why don't you create a straight table like this:

Dimension

Type

Expression

Sum(value)

On the presentation tab, uncheck 'Suppress Zero Values' to show 0 values.

[#3]

The requirement is to show all three columns by default but if a user select any value in list box then it should display that value online and remaining columns will show 0 as value

[sunny_talwar]

That is what the above will do

[sunny_talwar]

Try this as your expression:

=Sum(Value) + Avg({1} 0)

[#6]

Sorry, but I missed to say that dimensions is a country column.

[sunny_talwar]

Then create a pivot table and have two dimensions