New To Pivot Tables

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
 
E

Eduardo

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
 
B

Bob

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

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.
 
E

Eduardo

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,
 
B

Bob

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,

Perfect thank you Eduardo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top