I have a column in my pivot table that has been set up to display either a 0 or 1. How can I get the table to display only records where this column is 1? I tried using an if statement as a condition on the layout tab but it didn't work.

[#1]

I have a column in my pivot table that has been set up to display either a 0 or 1. How can I get the table to display only records where this column is 1? I tried using an if statement as a condition on the layout tab but it didn't work.

[#2]

You may try with Set Analysis.

There is also checkbox on Presentation tab:

Suppress Zero-Values

This check box eliminates columns or rows that contain only zeros from the table.

regards

Darek

[Anonymous]

use calculated dimension ;

if(field =1 ,1)

and check supress null values

hope it helps

Sri1

[#4]

Suppress Zero didn't seem to work. Have all the variables in that record have to be 0 for that to work?

[#5]

If all row should be presented what you would like to show instead 0?

Empty cell? or maybe '-'?

[#6]

Maybe my post is a little confusing. I want to eliminate any row that has a 0 in this certain field. Right now I'm showing 14 rows. 7 have a 1 in this particular field and 7 have a 0. I only want to show the rows where this field = 1.

[#7]

Please share your application. This will be easiest way to help.

[#8]

Use calculated dimension with following

If(field=1,field)

Select "Suppress When Value Is Null" option for this dimension.

[#9]

I only want data to display if 'Chng>Std Dev' has a 1 in it.

Here’s the expression for ‘Chng>Std Dev’

If(fabs(Column(4))>=Column(3),1,0)

[#10]

Am I suppose to put my column name in place of 'field'?