+ Reply to Thread
Results 1 to 2 of 2

"Concatenated" Pivot Data Filters

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    86

    "Concatenated" Pivot Data Filters

    Hello,

    I have two Pivot Data Filters: one for Part Number and one for Description. (Item: 111, Description: Part B | Item: 222, Description: Part A)
    Each of them is sorted alphabetically so, for each line, the description doesn't match the item. Here is an example (imagine these are sets of Pivot Data Filters).
    Item Description
    111 Part A
    222 Part B

    Do you have any suggestion on how to relate the two fields in order that Description follows the right Part Number?
    Item Description
    111 Part B
    222 Part A

    I know I could solve the problem with a concatenated field but the file is very complex with a lot of macro running on. Moving columns at the moment it is not that easy.

    Thanks for the help!

  2. #2
    Registered User
    Join Date
    09-12-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    38

    Re: "Concatenated" Pivot Data Filters

    Hi Brian
    I suspect the concatenated field would be you best bet, but don't move any columns, just add a new column and put in the formula =a1 & " " & b1 then add this column to the dataset for the pivot. if you add this column at the right hand side of your existing data is shouldn't upset the rest of the file.
    Ron

    Nothing is guaranteed

+ 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: 7
    Last Post: 03-06-2019, 05:01 PM
  2. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  3. [SOLVED] How to insert "," in figures that concatenated to other cells?
    By reimar_rem in forum Excel General
    Replies: 5
    Last Post: 12-16-2013, 02:44 AM
  4. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  5. Help Needed to get Filters Using "Include" and "Exclude" multiple values on one column.
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 04:03 AM
  6. Replies: 2
    Last Post: 01-26-2011, 06:45 AM
  7. Replies: 7
    Last Post: 08-10-2006, 06:20 PM

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