+ Reply to Thread
Results 1 to 3 of 3

do not include total in pivot table report

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    do not include total in pivot table report

    hi
    I have a pivot table report but seems to be littered with "total" in the report ,if I try to remove it this says this part of pivot table can not be removed
    can any one tell me if it can or why not,password if needed is (loler)
    cheers colin
    Attached Files Attached Files
    Last edited by cfinch100; 07-24-2014 at 08:57 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: do not include total in pivot table report

    How you trying to remove them?

    If I use PivotTable Tools > Design > Layout > Subtotals > Do not show sub totals. They go away.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: do not include total in pivot table report

    hi
    excellent many thanks new to pivot tables
    cheers colin

+ 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. Grand total in Pivot Table to include filtered records
    By poorcloud in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-09-2013, 02:23 AM
  2. Pivot table report, one column NOT showing the total
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2011, 08:14 PM
  3. a pivot table report cannot overlap another pivot table report
    By judyh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2007, 12:59 AM
  4. [SOLVED] A pivot table report cannot overlap another pivot table report.
    By David in forum Excel General
    Replies: 1
    Last Post: 06-23-2005, 07:05 PM
  5. How do I manipulate pivot table report to include percentage of?
    By KRUEMJ-Needs some help in forum Excel General
    Replies: 2
    Last Post: 01-30-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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1