View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew in Jax Andrew in Jax is offline
external usenet poster
 
Posts: 1
Default 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.