Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Totals | New Users to Excel | |||
Totals For a Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Grand Totals | Excel Worksheet Functions | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Highlighting(coloring) totals in a pivot table | Excel Worksheet Functions |