Hola1 I have a Pivot Table that in the values field, 5 or greater I need to display the row label expanded( Customer Name expanded). If the value of 4 or less I need the Row Labels (Customer Name collapsed). My goal is only to display the customers with 5 or more in all classrooms based on the classrooms selected.
An easy fix is to include a formula in your source table that returns TRUE/FALSE for every row, like
=COUNTIF(A:A,A2)>=5
And then use that field as a page filter, set to TRUE.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks