+ Reply to Thread
Results 1 to 5 of 5

Excel pivot table row labels and report filters

  1. #1
    Registered User
    Join Date
    10-27-2008
    Location
    Miami
    Posts
    25

    Excel pivot table row labels and report filters

    I've created a pivot table in excel with the following row labels:

    LAST NAME
    FIRST NAME
    MIDDLE
    SUFFIX
    DOB
    SOCIAL SECURITY #

    If I assign the LAST NAME column as a report filter, it removes it from the row labels. I would ideally like the report filter to have the LAST name column as well as the FIRST NAME column, but I would like both columns to still appear as row labels. Can this be done using a pivot table?

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    In the short term: I get around this by duplicating the column in the source data.
    In the medium term: I'd love to know a better way...

    HTH

  3. #3
    Registered User
    Join Date
    10-27-2008
    Location
    Miami
    Posts
    25
    i tried that but it didn't appear, i assumed it was because the information was duplicated. I will try that again and see. Int he meantime, if anyone else has any other suggestions they would be very appreciated.

  4. #4
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    Unless you inserted a column into the original range you will need to redefine the source data for your pivot, you will also need to "refresh data" in the pivot table. I personally like to use dynamic named ranges for defining source data for pivot tables:
    http://www.ozgrid.com/Excel/DynamicRanges.htm

  5. #5
    Registered User
    Join Date
    10-27-2008
    Location
    Miami
    Posts
    25

    Thumbs up

    (solved)
    thanks

+ Reply to Thread

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