Thread: Pivot Table:delete zero values when using calculated objects
View Single Post
 
Old 06-05-2013, 04:30 AM
Serge 007's Avatar
Serge 007 Serge 007 is offline Windows XP Office 2010 32bit
Novice
  
Join Date: Jun 2013
Posts: 6
Serge 007 is on a distinguished road
Default 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
Reply With Quote