Hey that is better, yet! I like that.
One other question if I could so ask. . .

I have data fields A and B with the calculation Diff (a-b) totaled by
category.

The Diff field does not total. Any suggestions?

"Debra Dalgleish" wrote:

If the pivot table is the only thing on the worksheet, you could hide
all the zeros:

Choose ToolsOptions
On the View tab, remove the check mark from Zero values
Click OK

Another option is to format the numbers to hide the zeros:

Right-click on a cell in the calculated field
Choose Field Settings
Click the Number button
In the Category list, choose Custom
In the Type box, enter the format for positive, negative, and zero.
For example:
#,##0.00_);(#,##0.00);
or
0;0;

Click OK, twice.

Candyman wrote:
How do I make the format of a calculated field equal white if the value is
zero. or the same color as the cell background?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html