+ Reply to Thread
Results 1 to 2 of 2

Pivot table grouping, adding description to cells

  1. #1
    Registered User
    Join Date
    05-19-2014
    Location
    california
    MS-Off Ver
    excel 2016
    Posts
    41

    Pivot table grouping, adding description to cells

    HI,


    I LIKE TO KNOW IF I CAN ADD WORDING TO AN EXISTING CELL AFTER I'TS ALREADY BEEN FILTERED. OR MAYBE ADD AN ADDITIONAL CELL TO MATCH ALREADY ANOTHER CELL.

    PLEASE TAKE A LOOK AT PIVOT TABLE YOU WILL SEE A SERIES OF NUMBER LIKE " 2PNC01234G4P9LH" this is a serial number and I will like it to say somewhere that it is a serial number. also, "314899" is the RMA number, but i would like for it to say RMA somewhere. so basically i would like for the viewer to know what each number or description means.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,279

    Re: Pivot table grouping, adding description to cells

    What about using a tabular report layout with the subtotals turned off as in the attached sample?
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. VBA for Grouping Cells that are copied from a Pivot Table
    By learning_vba in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2013, 09:47 AM
  2. Pivot Table-max min and description tabs
    By apetlu in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-03-2012, 12:52 PM
  3. Replies: 1
    Last Post: 07-29-2012, 12:49 PM
  4. Grouping empty cells in Pivot Table
    By Duke_ in forum Excel General
    Replies: 3
    Last Post: 12-20-2011, 03:29 PM
  5. description column in pivot table
    By jmhultin in forum Excel General
    Replies: 7
    Last Post: 08-10-2009, 02:03 PM
  6. Adding columns in Pivot Table having common description
    By sayvari in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2006, 09:43 AM
  7. Adding columns in Pivot Table having common description
    By sayvari in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-12-2006, 03:56 PM

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