+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Layot

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Pivot Table Layot

    I have the attached spreadsheet/pivot table. Table is on Sheet 1, Pivot Table is on Sheet 2, and basis for my question on Sheet 3. I'm trying to make the layout of the Pivot Table look as it does on Sheet 3 so that I can then apply slicers. Possible? Not Possible? And if so, how? Any help to get me to the next step would be greatly appreciated. Tks.
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Pivot Table Layot

    in your pivot add one under the other: BOM Line, Drawing...., Material and Item Number. Go to Design on the ribbon, select Subtotals - Do not show subtotals. Go to Report Layout and select Show in Tabular Form. Done

  3. #3
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Re: Pivot Table Layot

    Works perfect. Thanks for your help. Will probably be picking your brain with further questions about this in the future as this is part of a much larger on-going project and I learned about Pivot tables yesterday. Thanks again.

+ 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: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Automating Pivot table and pivot chart creation if data table names unknown
    By Vegiepie2016 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2016, 11:52 AM
  3. Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  4. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  5. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  6. Using dropdown menu to change "layot"
    By h0ps in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2012, 08:29 AM

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