Displaying Table data without list box selection

[#1]

Hi All,

I have two fields with 0,1 values and one straight table with 50 k records.

let 

Field A

-------

0

1

I want to display the straight table values where field value =0,

but I don't want to take the fields as list box to made selections.

Without list box selection how we can display the table data where Field value =0

Thanks in advance

[anbu1984]

You can use calculated dimension

If(FieldA=0,Dimension)

Then select "Suppress When value is Null"

[maleksafa]

use if condition like if(FieldA=0, put the dimension name here) or include it in your set analysis for the expressions.

example:

suppose you have 10 dimensions and one expression which is sum(sales), modify it to be sum({<FieldA=0>}sales)