Hi,
why you don't use another column for the calculation and then include this
column in your Pivot Table, selecting it for the totals

"Bob" wrote:

I am using Excel 2003.

I need to set up a a pivot table where the end data in the pivot table
is divided by 1000. so if in the original base table the value is
52,789 then the value in the pivot is senn as 53 (rounding up). this
is to apply to all values.

What is the best way to do this please. (If it makes a difference this
workbook is going to be used as a template each month - so new values
will be dropped into the base table next month - but the same divided
by 1000 will apply.)

Any help appreciated
.