Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables - Values divided by Subtotal Loretti Excel 0 11-12-2012 02:15 PM
Pivot Table:delete zero values when using calculated objects Inserting a date calculated from a table cell theMikeD Word 2 09-11-2012 05:46 PM
Excel Pivot Table Calculated Field BertLady Excel 0 05-21-2012 10:51 AM
Pivot table help TishyMouse Excel 2 04-27-2012 10:19 AM
Pivot Table:delete zero values when using calculated objects add values from different variables with pivot table andrei Excel 2 01-19-2012 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft