Results 1 to 10 of 10

Pivot Table: Remove Total

This is a discussion on Pivot Table: Remove Total within the Excel Questions forums, part of the Question Forums category; In my pivot table i just added another colum in the left side, and after it completes a section corresponding ...

  1. #1
    Board Regular
    Join Date
    Apr 2006
    Posts
    185

    Default Pivot Table: Remove Total

    In my pivot table i just added another colum in the left side, and after it completes a section corresponding to a value of the previous column it puts a total column.

    data 1 1
    2
    total 3
    2 0
    6
    total 6
    data2 1

    2

  2. #2
    Board Regular Domski's Avatar
    Join Date
    Jan 2005
    Location
    Leeds, UK
    Posts
    7,178

    Default

    Hi

    Right click on the field, select Field Settings and Subtotals...None
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    - Guidelines For Posting

    - Mr Excel Articles and PodCasts

    - Display sheet using HTML Maker or Excel Jeanie

    - Something that makes me laugh

    - Please try to remember to use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Board Regular
    Join Date
    Apr 2006
    Posts
    185

    Default

    Thanks


    how do i make the (blank) display nothing ""

  4. #4
    Board Regular Domski's Avatar
    Join Date
    Jan 2005
    Location
    Leeds, UK
    Posts
    7,178

    Default

    Don't quite follow what you mean.
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    - Guidelines For Posting

    - Mr Excel Articles and PodCasts

    - Display sheet using HTML Maker or Excel Jeanie

    - Something that makes me laugh

    - Please try to remember to use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    Thanks


    how do i make the (blank) display nothing ""
    Edit "(blank)" to make it " ".
    Windows XP Pro/Office 2003 SP2

  6. #6
    Board Regular
    Join Date
    Apr 2006
    Posts
    185

    Default

    how do you edit "(blank)"

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    how do you edit "(blank)"
    Click on the cell containing "(blank)", and enter " " in its place.

    You can edit any item in a PivotTable. For example, you can change 1 to "Yes" and 0 to "No".
    Windows XP Pro/Office 2003 SP2

  8. #8
    Board Regular
    Join Date
    Apr 2006
    Posts
    185

    Default

    The cell does not allow nothing in a cell, the message is as follows:
    "Cannot enter a null value as an item or field name in a PivotTable report"

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    The cell does not allow nothing in a cell, the message is as follows:
    "Cannot enter a null value as an item or field name in a PivotTable report"
    Enter a space character... char(32), " ".
    Windows XP Pro/Office 2003 SP2

  10. #10
    Board Regular
    Join Date
    Apr 2006
    Posts
    185

    Default

    Thanks so much

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com