No Pivot Table Totals Wanted
 

Is it possible to get pivot to not put the totals in for the Row area
besides going to each field and saying none under the "Field Settings"?
I put these pivot tables together, and everytime I have to go back and
change the field settings so I get no totals. I don't want the totals.
I thought through the table options by taking the checks out of the
grand totals and auto format it would take care of it but it doesn't.
Just getting tired of changing those settings individually each time.
Any ideas is there a way I hope someone has something or maybe I am
going brain dead let me know which please.
Thanks,
Bob


--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=392278

Hi Bob

Try downloading Debra Dalgleish's new Pivot Table Addin
http://www.contextures.com/xlPivotAddIn.html

--
Regards

Roger Govier


"robertjtucker"
wrote in message
news:robertjtucker.1t5i2e_1123009512.359@excelforu m-nospam.com...

Is it possible to get pivot to not put the totals in for the Row area
besides going to each field and saying none under the "Field Settings"?
I put these pivot tables together, and everytime I have to go back and
change the field settings so I get no totals. I don't want the totals.
I thought through the table options by taking the checks out of the
grand totals and auto format it would take care of it but it doesn't.
Just getting tired of changing those settings individually each time.
Any ideas is there a way I hope someone has something or maybe I am
going brain dead let me know which please.
Thanks,
Bob


--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile:
http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=392278