+ Reply to Thread
Results 1 to 10 of 10

Add descriptions in line on Pivot Table

  1. #1
    Registered User
    Join Date
    05-11-2015
    Location
    Richmond, VA
    MS-Off Ver
    2016
    Posts
    16

    Add descriptions in line on Pivot Table

    Hello - I have filters for a buyer and vendor, and I'm looking to give resultant item numbers and descriptions. I've tried a concatenation formula but I can't get item numbers and descriptions to display together. So I want the first column to be the item number and the second column to list the description. Third column to list description 2. See the attachment. Can someone help?
    Attached Files Attached Files
    Last edited by astumpf; 05-21-2020 at 09:38 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,851

    Re: Add descriptions in line on Pivot Table

    Please show the result manualy in the excel file, and post it again.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-11-2015
    Location
    Richmond, VA
    MS-Off Ver
    2016
    Posts
    16

    Re: Add descriptions in line on Pivot Table

    You mean the desired result?

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,851

    Re: Add descriptions in line on Pivot Table

    yes the desired result.

  5. #5
    Registered User
    Join Date
    05-11-2015
    Location
    Richmond, VA
    MS-Off Ver
    2016
    Posts
    16

    Re: Add descriptions in line on Pivot Table

    Quote Originally Posted by oeldere View Post
    yes the desired result.
    i've updated the attachment. check this message
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,851

    Re: Add descriptions in line on Pivot Table

    This looks the same file to me.

    Where do I find the expected results.

    Probably it is clear to you, but the file is new for me, so I don't see what is the result.

  7. #7
    Registered User
    Join Date
    05-11-2015
    Location
    Richmond, VA
    MS-Off Ver
    2016
    Posts
    16

    Re: Add descriptions in line on Pivot Table

    It's on the same page as the pivot table to the right. Very first tab.

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,851

    Re: Add descriptions in line on Pivot Table

    For the future, don't hide the result.
    It needs to be visiable so forummembers can check their solution.


    Purchased Parts

    J38 =B38 & " " &C38

    Then select header D1 & 2 in the pivot table.

    See the attached file.

  9. #9
    Registered User
    Join Date
    05-11-2015
    Location
    Richmond, VA
    MS-Off Ver
    2016
    Posts
    16

    Re: Add descriptions in line on Pivot Table

    Thanks Oeldere. I guess I didn't think about adding a row in the source data and calling that out. Your spreadsheet did help me where I pulled the settings to use "TABULAR" settings on the field, which helped align. Thank you!

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,851

    Re: Add descriptions in line on Pivot Table

    Glad I could help.

    Thanks for marking the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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