View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PsyberFox PsyberFox is offline
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?