Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2010, 05:34 PM
hannu hannu is offline Adding a Total row to pivot Table Windows Vista Adding a Total row to pivot Table Office 2007
Advanced Beginner
Adding a Total row to pivot Table
 
Join Date: May 2010
Location: Sydney, Australia
Posts: 30
hannu is on a distinguished road
Default Adding a Total row to pivot Table

I have a simple pivot table which has rows that sum the columns of values.

I want to add an extra TOTAL column to the right of the Pivot table to create a total for each row. How do I do that?

Thanks in advance



H

Last edited by hannu; 09-07-2010 at 05:47 PM. Reason: table not showing correctly
Reply With Quote
  #2  
Old 09-18-2010, 01:15 AM
BjornS BjornS is offline Adding a Total row to pivot Table Windows Vista Adding a Total row to pivot Table Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
when using the pivot guide, click the button "alternative" and then checkbox "sum of rows" (might not have exaclty those names in English version).

Kind regards
Bjorn
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding table lines to protected form razberri Word Tables 2 10-27-2010 05:58 PM
link comment to a pivot table dom585 Excel 0 07-15-2010 11:11 AM
pivot table source data hannu Excel 0 07-03-2010 04:54 AM
Adding a Total row to pivot Table Pivot table problem swindon Excel 5 05-25-2010 02:05 PM
Excel pivot table into an MS Word Doc "office 2007" wmarsh3561 Excel 1 01-09-2010 08:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft