I believe that you can click in the various Pivot columns, go to the
Insert menu, and select function, allowing you to enter formulas to
affect the displayed data. But I havent used it more than once myself
so Im unaware of its limitations or if it will work for you.

-Sean

Shams wrote:
Folks,
I wanted to know if there is any way that I can divide my Pivot Table data
by 1000. In other words,

Data
+/- lbs +/-Sales
Product
Canine Dry 1,100,000 10,500,000
Feline Dry 500,000 6,500,000

This is a representation of the Pivot Table. I now need to divide the
numbers by 1,000 so that Canine Dry +/- Sales becomes 10,500.

In an Excel worksheet this is easy to do (Copy 1,000 and Edit Special divide
by 1,000 over your data range). I do not want to touch my Original Pivot
Data source.

Thanks for your help.

Shams.