Pivot Table Hiding Totals = Zero

M

Mnilo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top