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
|
|||
|
|||
Pivot table questions
2 questions:
1)I created a custom pivot table format, but I am unable to use it for other documents than the one I created it into. Any idea on how to do it? I would like to use this style for every single pivot table I create. 2) When I create a pivot table from a data (numbers) sheet, I always display the numbers in the pivot report as "sum of" and not "count". How do I set this to be the standard format? When having a lot of colums in the pivot, it's quite a waste of time to change all of them in "sum of" from "count". Thanks Francesco |
#2
|
|||
|
|||
Pivot table questions
In Excel 2007 you can create custom pivot table styles, but not in
earlier versions. You could record a macro as you format the pivot table, then modify the macro to make it generic. Run that macro to format other pivot tables. 2) You can't change the default summary function for pivot tables. If a field in the source data contains blank cells or text, it will default to Count Of if you add it to the data area. If a field is all numbers, it will default to Sum Of. There's an add-in here that you can download. It has a command that will set all the data fields to Sum. http://www.contextures.com/xlPivotAddIn.html Francesco wrote: 2 questions: 1)I created a custom pivot table format, but I am unable to use it for other documents than the one I created it into. Any idea on how to do it? I would like to use this style for every single pivot table I create. 2) When I create a pivot table from a data (numbers) sheet, I always display the numbers in the pivot report as "sum of" and not "count". How do I set this to be the standard format? When having a lot of colums in the pivot, it's quite a waste of time to change all of them in "sum of" from "count". Thanks Francesco -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Thread Tools | |
Display Modes | |
|
|