If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
New To Pivot Tables
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 |
#2
|
|||
|
|||
New To Pivot Tables
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 . |
#3
|
|||
|
|||
New To Pivot Tables
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. |
#4
|
|||
|
|||
New To Pivot Tables
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. . |
#5
|
|||
|
|||
New To Pivot Tables
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 |
Thread Tools | |
Display Modes | |
|
|