+ Reply to Thread
Results 1 to 2 of 2

Pivot Table:delete zero values when using calculated objects

  1. #1
    Registered User
    Join Date
    06-05-2013
    Location
    Moscow, Russia
    MS-Off Ver
    Excel 2010
    Posts
    8

    Pivot Table:delete zero values when using calculated objects

    Hi, everybody!

    In Pivot Table create calculated object. However at its application zero values of fields become visible. How not to display them, but to use calculated object?

    In PT_object.xls in detail I drew - that turns out (the table at the left, excess values are filled in red) and that it is necessary to receive (the right table)

    Thanks!

    P.S. Sorry for my English, i used the Internet translator
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-05-2013
    Location
    Moscow, Russia
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Pivot Table:delete zero values when using calculated objects

    Friends!
    My question is so difficult?
    Or it has no decision?

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1