PivotTable question

I have a table that has these 3 fields I'm trying to use in a pivot table.
1. Industry name - e.g. retail, automotive, healthcare, etc.
2. Project name
3. Total Contract Value (TCV)

I drop Industry name in the Drop Row Fields Here. I drop Project Name in the
Drop Data Items Here. And I drop Total Contract Value in the Drop Column
Fields Here. Great, that works fine. But I want to filter the the table
such that I only get projects with a TCV of less than 50 in the table. I
haven't found a way to do this in the pivot table yet but I'm sure there
must be a way. Any help would be greatly appreciated.

On Mar 9, 1:51 pm, "Kent McPherson" wrote:
> I have a table that has these 3 fields I'm trying to use in a pivot table..
> 1. Industry name - e.g. retail, automotive, healthcare, etc.
> 2. Project name
> 3. Total Contract Value (TCV)
>
> I drop Industry name in the Drop Row Fields Here. I drop Project Name in the
> Drop Data Items Here.  And I drop Total Contract Value in the Drop Column
> Fields Here.  Great, that works fine.  But I want to filter the the table
> such that I only get projects with a TCV of less than 50 in the table.  I
> haven't found a way to do this in the pivot table yet but I'm sure there
> must be a way.  Any help would be greatly appreciated.

I haven't tried it yet, but there is a filter that you can be applied
to fields. Also, if you could post the version of Excel that you're
using, that will help people answer your question better.