+ Reply to Thread
Results 1 to 3 of 3

Pivot table format

  1. #1
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    106

    Pivot table format

    Good afternoon!
    I am working with pivot tables for the first time in maybe 12 years. Trying to remember how to get the thing laid out correctly. I have gotten rows and columns close to what I want, it's totaling correctly, I've removed grand totals and formatted the pivot table. What I can't do is get the finished product to line up one 3 adjacent columns. What I want is to have Code, Description and Sum of Total Qty in adjacent columns without bollixing up the rest of it. Memories are short, and mine is shorter than most. I am sure I used to be able to do so but danged if I can remember how. The Google machine has not helped. Any help would be very much appreciated! I have attached the file in hopes that someone knows how to do this.
    Thanks very much,
    Bill
    Attached Files Attached Files

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    1,335

    Re: Pivot table format

    Well in those 12 years they came up with the new compact form as default layout.
    I think you want to revert back to Tabular from (the default 12 years ago)

    While anywhere in the pivot table go to Pivotable tools > Design > Report layout
    and pick the option "Show in tabular form"

    maybe this info can help you understand the "new" pivottable formats

    https://support.office.com/en-us/art...e-641133c05a80
    Last edited by Roel Jongman; 02-07-2019 at 03:34 PM. Reason: link added

  3. #3
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    106

    Re: Pivot table format

    Roel Jongman,
    That is exactly what I was trying to do. I really appreciate your help with this and now I have some reading material for tonight!
    Thanks very much!
    Bill

+ 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