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

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
.

On 19 Apr, 17:12, Eduardo wrote:
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
.

I have 21 columns and 59 rows, we have some high volumes / values and
the directors just want to quickly pick out the salient items.

Hi, in that case try this

highlight the column in the Pivot table, right click on the mouse, cell
format, custom and copy this format

0.00,



"Bob" wrote:

On 19 Apr, 17:12, Eduardo wrote:
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
.

I have 21 columns and 59 rows, we have some high volumes / values and
the directors just want to quickly pick out the salient items.
.

On 19 Apr, 18:21, Eduardo wrote:
Hi, in that case try this

highlight the column in the Pivot table, right click on the mouse, cell
format, custom and copy this format

0.00,

"Bob" wrote:
On 19 Apr, 17:12, Eduardo wrote:
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
.

I have 21 columns and 59 rows, we have some high volumes / values and
the directors just want to quickly pick out the salient items.
.

Perfect thank you Eduardo