+ Reply to Thread
Results 1 to 3 of 3

Remove subtotals for rows only

  1. 08-12-2020, 09:36 AM #1
    mp3909
    mp3909 is offline
    Forum Contributor
    Join Date
    06-14-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    186

    Remove subtotals for rows only

    I am trying to replicate the following pivot layout/design - as you can see, it has total columns (highlighted in yellow)

    Capture1.PNG

    The closest I can get to is the following but then I do not want to show those totals I have highlighted in green. As you can see, the original pivot above does not show this.

    Capture2.PNG

    Does anyone know how to solve this?

    Thank You.
    Reply With QuoteRegister To Reply
  2. 08-12-2020, 09:38 AM #2
    CK76
    CK76 is online now
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,880

    Re: Remove subtotals for rows only

    Right click on Row label field with subtotal -> Untick Subtotal - "Field Name".
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  3. 08-12-2020, 10:20 AM #3
    mp3909
    mp3909 is offline
    Forum Contributor
    Join Date
    06-14-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    186

    Re: Remove subtotals for rows only

    ahh, perfect!
    so simple but I never knew.

    Thank You.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to remove subtotals from pivot table
    By devawad in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-05-2017, 07:20 AM
  2. [SOLVED] formula Remove blank rows where applicable with subtotals through an export interface
    By JEAN1972 in forum Excel General
    Replies: 6
    Last Post: 07-29-2014, 11:10 AM
  3. code to remove subtotals from pivot table
    By mashley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2008, 12:50 PM
  4. Remove subtotals from multiple sheets
    By punter in forum Excel General
    Replies: 1
    Last Post: 08-10-2007, 01:45 AM
  5. How to remove Subtotals
    By nander in forum Excel General
    Replies: 1
    Last Post: 02-21-2006, 02:00 PM
  6. [SOLVED] remove subtotals from pivot tables
    By ChristinaC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2005, 08:06 AM
  7. Remove the word 'total' from subtotals
    By yahoo in forum Excel General
    Replies: 2
    Last Post: 02-12-2005, 10: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1