Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Thread Tools
Display Modes


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 06:03 AM.


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