Geek Answers Handbook

Excel 2007 PivotTable Tables Custom Calculation?

Again I struggle with Excel 2007! I have some data that I use to create a pivot table and I would like to split all the data by 1000 ...

I know that I can enter and change the source data manually, but I would rather have a formula in the Pivot table itself that does this for me.

Any thoughts?

ps: You guys are awesome!

+4
source share
1 answer

Create a pivot table, then in the parameters of the pivot table, select Formulas / Insert calculation field. Assuming your data field is named MonthlySum, then formulat will be = MonthlySum / 1000. Change the name of the Calculation field as desired. Now the new calculated field will be available for adding values ​​to the pivot table. As a side note, you cannot use calculated fields as line labels.

+4
source

More articles:


All Articles