+ Reply to Thread
Results 1 to 2 of 2

Subtotals and design

  1. #1
    Registered User
    Join Date
    06-15-2018
    Location
    North Carolina
    MS-Off Ver
    16.14.1
    Posts
    7

    Subtotals and design

    Dear good people of excelforum.com,

    I need some guidance on designing a pivot table. In the attached image, you can see that I'm working with a pivot table w/ percentage data. Where I'm being held up is with the subtotals.

    I'm suppose to maintain the grey total line under each year ("2017 total" and "2016 total") as well as the grand total at the bottom. However, I need to remove the "COM total" and column totals ("A1 total", "A10 total", etc). When I remove the column totals in the design tab, I lose the grey line as well. How do I keep the yearly totals and the grand total, while losing everything else?
    Last edited by msexcelguy; 06-17-2018 at 01:10 PM.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Subtotals and design

    There's no image.

    You would be better off attaching a sample workbook rather than an image.

    Go Advanced -> Manage Attachments -> Upload

+ 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: 1
    Last Post: 11-22-2015, 08:35 AM
  2. Replies: 4
    Last Post: 06-06-2013, 10:21 AM
  3. create subtotals and copy subtotals to a new sheet with VBA
    By tonupgirl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2012, 01:36 AM
  4. Subtotals: Nested subtotals below higher subtotal
    By RobN in forum Excel General
    Replies: 1
    Last Post: 07-20-2006, 04:10 PM
  5. Replies: 1
    Last Post: 06-20-2005, 07:05 PM
  6. [SOLVED] Problem with nested subtotals, placing secondary subtotals BELOW .
    By Dawn Cameron in forum Excel General
    Replies: 1
    Last Post: 06-03-2005, 06:05 PM
  7. [SOLVED] Hyperlinks Inserted in Design Mode inactive once Exited Design Mod
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2005, 01:06 PM

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