Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Tables for excel 2010 total count greater than 5

    Hello-I would like my pivot table to display only the total counts greater than 5. How can I do this in a pivot table? I currently have totals on the pivot table that are from 1 to 15 but I am only interested in everything 5 or greater. Any help would be greatly appreciated.

  2. #2
    Lounger
    Join Date
    Aug 2014
    Posts
    31
    Thanks
    11
    Thanked 0 Times in 0 Posts
    Select the drop down of the column to the immediate left of your Total column.
    Select Value Filters.
    Select Greater Than or Equal To.
    Make sure the first box is set to 'Count Of.....', then put 5 in the third box.

    Should do it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •