Pivot Table - Field Subtotal Titles

[DaveBlackman]

I have created the pivot table that I want but I would like to know if it is possible to edit the fieldname Total information at the head of the column for each grouping. Also any tips on alternate record shading and managing printing of multiple page tables would be awesome.

 

[alansidman]

Here are a couple of links on pivot tables. I am sure that you will find them informative. Scroll down a bit to get to the PT section.

http://www.datapigtechnologies.com/ExcelMain.htm

Here is a second tutorial that is more advanced but extremely informative.

http://www.datapigtechnologies.com/WebinarResources.htm

alan

 

[DaveBlackman]

alan,
Thanks for your rapid response. Some really nice tips in those links!
I'm still looking for some tips on producing some hard copies of my tables in a specific format.