Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Pivot Table Hiding Totals = Zero

Hello all:

I have a pivot table that sum the sales of every seller during a period of
time as you can see below, IŽd like to know how to achieve the pivot table
doesnŽt show the sales people when the total sum of sales is cero
(automatically)


Sales Men Total

Sales Man 1 25
Sales Man 2 7
Sales Man 3Sales
Man 4 12
Total general 44

IŽm using Excel 2003

Thanks in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - Hiding Zero Values lcrean Excel Discussion (Misc queries) 2 September 3rd 08 12:21 PM
Pivot Table Chart - With Pivot Table Totals WCM Charts and Charting in Excel 0 November 29th 06 03:21 PM
Pivot Table hiding row removes from row ! Fullam Excel Discussion (Misc queries) 1 April 15th 06 12:44 AM
Hiding one subtotal in a pivot table MarkM Excel Discussion (Misc queries) 1 December 30th 05 09:30 AM
Pivot Table Totals Adam New Users to Excel 0 March 25th 05 04:57 PM


All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"