LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default Pivot Totals: Group totals different from Grand totals

Hi there,

Is there a way to have the grand total do something different than group
totals? For example:

ClockNo Target Date
040 02/02/08 04/02/08 05/02/08
Grand Total
2400 Qty 1133 875 875
2883
Efficiency 47% 37% 37%
121%

This grand total is obviously wrong... is there another way of doing it?
 
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
Grand Totals with Nested Sub Totals Brenda from Michigan Excel Discussion (Misc queries) 7 January 18th 08 01:26 PM
Pivot Tables - Grand Totals Tony Excel Discussion (Misc queries) 2 May 31st 06 02:06 PM
Need help with grand totals in pivot table Missygal Excel Discussion (Misc queries) 1 May 16th 06 07:02 PM
display grand totals on pivot chart maryj Charts and Charting in Excel 0 May 16th 05 06:55 PM
Pivot Table Grand Totals Adam Excel Worksheet Functions 0 March 25th 05 04:55 PM


All times are GMT +1. The time now is 10:24 AM.

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"