Results 1 to 5 of 5

Filter Pivot Tables By Values

Threaded View

Raoul Duke Filter Pivot Tables By Values 02-15-2010, 02:14 PM
Palmetto Re: Filter Pivot Tables By... 02-15-2010, 05:23 PM
Raoul Duke Re: Filter Pivot Tables By... 02-16-2010, 06:29 AM
Palmetto Re: Filter Pivot Tables By... 02-16-2010, 08:19 AM
Raoul Duke Re: Filter Pivot Tables By... 02-16-2010, 08:25 AM
  1. #1
    Registered User
    Join Date
    02-14-2008
    Posts
    25

    Filter Pivot Tables By Values

    Hi,

    I have a Pivot Table which looks something like this:

    -------------------Links
    Sites ---- Ok ---- #N/A
    abc.com ---1,479 --- 10,517
    xyz.com --- 517 ---244
    dfas.com ---548 --- 892
    htfh.com --- 845 --- 218

    What I'd like to be able to do is filter the data by two conditions; e.g. where OK is greater than 500 and #N/A is less than 750.

    I can't seem to be able to work out a way of doing this easily. If it was plain data the I could do it with a couple of filters but by necessity it's a Pivot.

    I had a search on here but couldn't see anything which looked like what I'm trying to accomplish.

    Any help appreciated :-)
    Last edited by Raoul Duke; 02-15-2010 at 02:17 PM. Reason: Made clearer

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1