+ Reply to Thread
Results 1 to 7 of 7

Pivot Table - Grand Total Row - Blanking out Avg Summaries

  1. #1
    Registered User
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    2013
    Posts
    76

    Pivot Table - Grand Total Row - Blanking out Avg Summaries

    Hi,

    In a pivot table, is there a way to either blank out avg columns or show zero's in the grand total row of a pivot table. See attached file.

    Thanks in advance

    -Manny
    Attached Files Attached Files
    Last edited by Prof Sick; 05-08-2020 at 06:05 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Pivot Table - Grand Total Row - Blanking out Avg Summaries

    I do not know that it is possible.

    But you can make a second pivot table, and on that pivot table it is possible to NOT add an endtotal.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    2013
    Posts
    76

    Re: Pivot Table - Grand Total Row - Blanking out Avg Summaries

    Thanks for your time. I was afraid there was a limitation in trying to do that.

    -Manny

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Pivot Table - Grand Total Row - Blanking out Avg Summaries

    Glad I could help.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,888

    Re: Pivot Table - Grand Total Row - Blanking out Avg Summaries

    You could format those two Grand Total cells such that font color mirrors the background (thus rendering them 'invisible', albeit still present)

  6. #6
    Registered User
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    2013
    Posts
    76

    Re: Pivot Table - Grand Total Row - Blanking out Avg Summaries

    Excellent suggestion! Worked perfectly...

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Pivot Table - Grand Total Row - Blanking out Avg Summaries

    @XLent

    nice workaround.

+ 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: 11
    Last Post: 09-27-2019, 08:00 AM
  2. [SOLVED] Pivot Table Grand total issue need two grand totals
    By alesha711 in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 02-13-2019, 03:02 PM
  3. More than one grand total in a pivot table
    By kmb100 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2017, 10:01 PM
  4. Replies: 6
    Last Post: 09-29-2015, 08:44 PM
  5. [SOLVED] Is it possible to have both Grand Total and Grand Average in a Pivot Table?
    By ANS in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 10-16-2012, 05:15 AM
  6. Pivot Table - Sub Total & Grand Total Filter
    By ramki in forum Excel General
    Replies: 1
    Last Post: 08-07-2009, 11:40 PM
  7. % of Running Total to Grand Total in Pivot Table
    By David in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2005, 04:05 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