+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Grand Total

  1. #1
    Forum Contributor
    Join Date
    01-08-2013
    Location
    Goergia USA
    MS-Off Ver
    Excel 2007
    Posts
    102

    Pivot Table Grand Total

    Hi All,

    I need some help.

    I have a pivot table (see attached image) which has the dates in columns A and B, and the Company names in the columns to the right of that. The last column in the Pivot Table is the Grand Total.

    Now, is there a way to place a Grand Total Column as the third column (column C)?

    Any help would be greatly appreciated.

    Thank so much!!
    Attached Images Attached Images

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: Pivot Table Grand Total

    Hey marshak,

    Make your Company Names a filter instead of a Column and see if that does what you need.
    IE, Drag Company Name from the Columns box to the Filter Box while looking at the Pivot Table List.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    01-08-2013
    Location
    Goergia USA
    MS-Off Ver
    Excel 2007
    Posts
    102

    Re: Pivot Table Grand Total

    Thanks so much for your reply. Your method worked, but I needed the Company Names to also remain as columns. Here's what I ended up doing. I am hoping that it works ok.

    Basically, I:
    1. Created a second Pivot Table (in the same worksheet) that contained only three columns (Years, Event Date, and Grand Total)
    2. Took out Grand Total column in the original Pivot Table
    4. Hid the first two columns from the original pivot table

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 09-29-2015, 08:44 PM
  2. [SOLVED] Is it possible to have both Grand Total and Grand Average in a Pivot Table?
    By ANS in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 10-16-2012, 05:15 AM
  3. [SOLVED] Pivot Table - % of Grand Total
    By montanaheather in forum Excel General
    Replies: 5
    Last Post: 09-14-2012, 09:50 AM
  4. Pivot table % to Grand total
    By mangeshp4 in forum Excel General
    Replies: 6
    Last Post: 08-17-2010, 06:42 AM
  5. Pivot Table Grand Total
    By coolzero in forum Excel General
    Replies: 1
    Last Post: 06-25-2010, 03:46 AM
  6. Pivot Table - Sub Total & Grand Total Filter
    By ramki in forum Excel General
    Replies: 1
    Last Post: 08-07-2009, 11:40 PM
  7. [SOLVED] % of Running Total to Grand Total in Pivot Table
    By David in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1