ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot Tables - Filtering on summed values (https://www.excelbanter.com/excel-programming/445430-pivot-tables-filtering-summed-values.html)

Gerry[_9_]

Pivot Tables - Filtering on summed values
 
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.


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com