#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
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 |
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 |