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.
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.