Filter for items greater than

[OzarkFan]

I'm trying to filter for items greater than 30 in my pivot table, but it's not doing that. I selected that in my filter but the data is still showing. Any help is greatly appreciated.

[6StringJazzer]

You are filtering on row labels, which are text. You have several numeric columns. Which one do you want to filter on?

Please Login or Register  to view this content.

[OzarkFan]

I'm trying to filter for items greater than 30 in my pivot table, but it's not doing that. I selected that in my filter but the data is still showing. Any help is greatly appreciated.

I was trying to filter a text value and not a number. I figured it out.

How do I pull up a calculated field, though? I keep reading to right-click the table, but that doesn't bring up the formula.

[josephteh]

Click on the funnel icon in cell A4 > Value Filters > Greater Than or Equal To > Select which field you want to filter.