Pivot Tables

G

Gerry

When I invoke my pivot table I am presented with circa 200 columns
and 450 rows. The value field settings is "sum of hours". I am only
interested in seeing cells where the sum of hours is greater than
20. That would cut my pivot table down to a very handy 20 columns by
30 rows.

Can I invoke a filter within the pivot table to achive that.

Thanks

GErry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables - Filtering on summed values 0
Dealing with a Pivot Table (when I don't want to) 0
Pivot Tables and Filter Criteria Display 0
Countifs or a pivot 1
Pivot table and value range 2
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters 1
Pivot table data layout - columns to rows 1
Bringing over text fields into pivot tables 4

Top