Grand Total on Pivot Table turned on but no totals showing




I am trying to display Grand Totals for Rows in my Pivot table. I have
selected the Grand Total for Rows option but to no avail. Any ideas
would be appreciated
Thanks


--
GaryRitchie
------------------------------------------------------------------------
GaryRitchie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24331
View this thread: http://www.excelforum.com/showthread.php?threadid=379317

.



Relevant Pages

  • Re: Differences instead of sums in pivot table
    ... Right-click on a cell in the pivot table, ... Remove the check mark from Grand Totals for Rows, ... I've attached a small pivot table with some demo data to illustrate a ... Product Type Sale Date Quantity ...
    (microsoft.public.excel)
  • Re: Row Grand Totals in Pivot Tables?
    ... If every question is in a separate column in the source data, then you're adding them to the pivot table as separate fields in the data area. ... "Debra Dalgleish" wrote: ... I have turned on row grand totals in the design menu and in the pivot table options menu but they just won't show up. ...
    (microsoft.public.excel.charting)
  • Re: Pivot Table Totals When Using Pages
    ... On PT sheet in E4 type % Non Billable ... Format column E to look like PT format. ... I have a pivot table that lists hours of several employees. ... table while maintaining the complete grand totals (all hours - both ...
    (microsoft.public.excel)
  • Re: How do I perform extended calculations in a Pivot Table in Exc
    ... totals as well as the cumulative grand totals for each Item. ... From the raw data in a worksheet, I created a Pivot Table shown below. ... Make these additional calculations dynamic so that whenever the original ... A third column showing the calculated ratio of the Pass to Grand Total ...
    (microsoft.public.excel.misc)
  • Re: calculating differences in a pivot table
    ... De-select Grand Totals by ... Right click again and choose Pivot Table Wizard>Layout>drag Sales amount to ... the difference between the 2 years for each customer rather than ...
    (microsoft.public.excel.worksheet.functions)