C
ccarns
This issue can be seen quickly by downloading a sample excel file I pu
together for the question (no macros)
Full explanation is included in the file:
http://www.ctc-dev.com/excel/pivottablesample.xls
I am running into issues because I am having to use an average instea
of a sum in one of the column fields in a pivot table. Because of thi
average field, all the subtotals and percentage columns based on thi
field are all thrown off
+----------------------------------------------------------------
| Attachment filename: pivottablesample.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=361258
+----------------------------------------------------------------
together for the question (no macros)
Full explanation is included in the file:
http://www.ctc-dev.com/excel/pivottablesample.xls
I am running into issues because I am having to use an average instea
of a sum in one of the column fields in a pivot table. Because of thi
average field, all the subtotals and percentage columns based on thi
field are all thrown off
+----------------------------------------------------------------
| Attachment filename: pivottablesample.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=361258
+----------------------------------------------------------------