+ Reply to Thread
Results 1 to 4 of 4

Cannot filter or sort in a pivot table

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Middle East
    MS-Off Ver
    Excel 2010
    Posts
    60

    Cannot filter or sort in a pivot table

    Hi guys,

    Please look on the attached pivot table example I made.

    For some reason, I can't do some actions:
    - I can't sort the clicks values for example.
    - I can't filter for example rows in table which got more than 15 clicks.


    Why is that?


    Thank you,

    Moty
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Cannot filter or sort in a pivot table

    Hi Moty,

    click on campaign Name filter ---go to value filter ----click on greater than ---select sum of clicks ----write 15 in third tab then ok

    Thanks,
    A

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    Middle East
    MS-Off Ver
    Excel 2010
    Posts
    60

    Re: Cannot filter or sort in a pivot table

    Thanks Amy.
    Earlier I encountered a case in which I couldn't for some reason filter. Can't recreate right now.

    What about the sorting?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Cannot filter or sort in a pivot table

    you can sort but it does not do what you want-you have to sort the campaign name by Sum of Clicks but it sorts on the total clicks for each campaign
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-08-2013, 07:16 AM
  2. Pivot table or filter to sort data?
    By merryquant in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 03-13-2013, 12:39 PM
  3. Replies: 3
    Last Post: 11-19-2012, 11:05 PM
  4. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 PM
  5. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM

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