New To Pivot Tables

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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
 
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
Click to expand...

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,
 
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,
Click to expand...

Perfect thank you Eduardo
 
Back
Top