+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - formatting data shown

  1. #1
    Registered User
    Join Date
    11-12-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    4

    Lightbulb Pivot Table - formatting data shown

    I have a pivot table I generated from another table with a lot of data.

    I was to have this table by supplier, so I know the sub-total I'm spending by supplier. But I also want to know some details about the products I'm buying from each supplier.

    The problem is, playing around with the pivot table and its design, changing from compact-outline-tabular, the best design I could get so far is not good enough. I wan it in a tabular way apparently. However, each time I add a new info (a new column), the info is not only added in a new column, but also in a new row, under the line of the product it is referenced from. In addition to that, it generates duplicate values, that are not summed up in the totals, but generate a visual pollution. I need this table to be as simple as possible for anyone understand it and work with it.

    excel sheet.jpg

    How could I make the model, quantity and whatever else I decide to add to be in the same row as the product name?

    Thank you! =)

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Pivot Table - formatting data shown

    If it's a numerical value like QTY then you can probably just move it to the VALUES field instead of the ROWS field and that should do it.

    Other than that, probably the easiest solution would be to stick a helper column into the data table that concatenates Product & Model into one column for you to use in the ROWS field. You could name the column something like "Product / Model" to make it easy to understand in the pivot table too.

    That would be my approach, unless I needed something really clever.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ 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. access pivot table chart with multiple Ranges shown
    By superchew in forum Access Tables & Databases
    Replies: 1
    Last Post: 09-29-2014, 12:48 AM
  2. Pivot Table (extracted data from pivot, in source formatting)
    By nsumitg in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-06-2013, 08:55 AM
  3. [SOLVED] remove the blank row shown in pivot table
    By markDuffy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2013, 03:45 PM
  4. Replies: 0
    Last Post: 02-20-2012, 02:53 PM
  5. Replies: 2
    Last Post: 04-14-2011, 09:33 AM
  6. [SOLVED] Pivot table - how to get two data fields shown in two columns
    By Seamus O'Connell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2006, 09:35 AM
  7. [SOLVED] why is the data row in pivot table incompletely shown?
    By buumoon in forum Excel General
    Replies: 1
    Last Post: 02-06-2006, 05:10 AM

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