ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table - Filter - no filter by value (https://www.excelbanter.com/excel-discussion-misc-queries/243087-pivot-table-filter-no-filter-value.html)

Andrew in Jax

Pivot table - Filter - no filter by value
 
Hello everyone.

In working with a pivot table, and the report filter field, there does not
seem to be a filter by value option available.

I'm doing two pivot tables side by side for comparison. One table shows full
count of items, the 2nd one shows count of items under 70%.

So far I've been manually de-selecting items from the report filter drop
down that exceeded the 70% criteria.


All times are GMT +1. The time now is 04:01 PM.

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