Results 1 to 7 of 7

Double click on filtered value pivot table value will return wrong data

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Braga, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Double click on filtered value pivot table value will return wrong data

    Hello,
    I have the following data on a sheet:

    Report Claim
    100001 100
    100002 101
    100007 106
    100007 107
    100010 110
    100010 111
    100010 112
    100015 114
    100015 115

    Then I inserted a pivot table based on the range of the above data as it follows:

    Row Labels Count of Claim issue
    100001 1
    100002 1
    100007 2
    100010 3
    100015 2
    Grand Total 9

    Now I need to filter the values so that I can only see the reports that close more than one claim.
    Then I go to Value Filters, Greater than, and finally I write 1, and the result is as follows:

    Row Labels Count of Claim issue
    100007 2
    100010 3
    100015 2
    Grand Total 7

    Which is exactly what I want. But if I double click the Grand Total Result (7), this is what I get:

    Report Claim issue
    100001 100
    100002 101
    100007 106
    100007 107
    100010 110
    100010 111
    100010 112
    100015 114
    100015 115

    I am seeing the entire data when I only want to see the 7 records I filtered previously, i.e. records 100001 and 100002 should not be displayed.
    What is wrong? Does anybody have any clues?
    Thanks,
    Jose
    Last edited by macroqmm9; 03-11-2013 at 10:10 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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