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 |
All times are GMT +1. The time now is 03:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com