Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
use calculated dimension ;
if(field =1 ,1)
and check supress null values
hope it helps
Sri1
Suppress Zero didn't seem to work. Have all the variables in that record have to be 0 for that to work?
If all row should be presented what you would like to show instead 0?
Empty cell? or maybe '-'?
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.
Please share your application. This will be easiest way to help.
Use calculated dimension with following
If(field=1,field)
Select "Suppress When Value Is Null" option for this dimension.
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)
Am I suppose to put my column name in place of 'field'?