LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
SSJ SSJ is offline
external usenet poster
 
Posts: 58
Default PIVOT TABLE - GRAND TOTAL COLUMN

Hello,

I am unable to get the the grand total column on the right as shown below. I checked the 'Table Options' and the 'Grand totals for columns' is checked. So I am notsure what else to check.

Thanks
SJ

Data
CUSTOMER WO# Sum of LAB COST Sum of LAB OVHD Sum of MAT COST
FIENG 29599 96,745.00 145,114.00 110,742.00
48804 3,864.00 5,796.00 537.00
49537 - - 3,714.00
49626 18,778.00 28,167.00 8,641.00
FIENG Total 119,387.00 179,077.00 123,634.00

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - how do I add a column? ajnmx Excel Worksheet Functions 1 November 25th 06 04:17 PM
PIVOT TABLE COLUMN Wes Excel Discussion (Misc queries) 3 August 18th 06 11:08 PM
Pivot Table external XLS file source change and GETPIVOTDATA refresh mbobro Excel Discussion (Misc queries) 0 July 8th 06 12:45 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 02:35 PM
add a column to a pivot table that would show the difference between 2 other Columns [email protected] Excel Worksheet Functions 7 January 30th 05 05:21 PM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"