+ Reply to Thread
Results 1 to 5 of 5

Thread: Pivot table - not to display 0 in grand total

  1. 06-23-2011, 01:26 AM #1
    Harrold
    Harrold is offline
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    64

    Pivot table - not to display 0 in grand total

    Hi

    please advise me how can pivot table not to display 0 in grand total column and row. I only want to those row with figures except 0 to be displayed.

    Thanks
    Reply With Quote Reply With Quote
  2. 06-23-2011, 09:32 AM #2
    Harrold
    Harrold is offline
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Pivot table - not to display 0 in grand total

    pump. no reply
    Reply With Quote Reply With Quote
  3. 06-23-2011, 12:37 PM #3
    Harrold
    Harrold is offline
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Pivot table - not to display 0 in grand total

    can someone please help?
    thanks
    Reply With Quote Reply With Quote
  4. 06-24-2011, 08:52 AM #4
    Harrold
    Harrold is offline
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Pivot table - not to display 0 in grand total

    Is there a solution to the above issue? Can someone help?

    Thanks
    Reply With Quote Reply With Quote
  5. 06-24-2011, 08:58 AM #5
    martindwilson
    martindwilson is online now
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    10,788

    Re: Pivot table - not to display 0 in grand total

    post your workbook
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and a dabbler in Cisco
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With Quote Reply With Quote
+ 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)

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.2.0