+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - Grand Total for Rows

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    Detroit
    MS-Off Ver
    2010
    Posts
    1

    Pivot Table - Grand Total for Rows

    This question has been asked but I am not able to figure out what the meaning of the replies are and that’s why I thought, I will ask this question again with some pictures.
    I needed to get a Grand Total of the Rows when I select the different fields, in the same fashion that I see the Grand Total of the Columns.

    For example,

    Var 1 and 2.JPG


    Pic 1: When I select Variable 1 and Variable 2 in the fields, I should be able to see 174 (122+52)


    And


    Var 1 and Var 2 and Var 3.JPG

    Pic 2: And when I select Variable 1, Variable 2 and Variable 3 in the fields, I should be able to see 518 (122+52+344).

    Is this something feasible?

    I read from others that if I drag and drop a field to the column labels section, then I can see Grand Total for the rows. This is true, but this is valid for only one field.

    Thanks a lot in advance for reading this. I am using Microsoft Office 2010.

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

    Re: Pivot Table - Grand Total for Rows

    Hi and welcome to the forum,

    Is this what you are looking for?

    https://support.office.com/en-us/art...F-310826F3E5E2
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. [SOLVED] Get first 5 rows from pivot table and grand total of overall data
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2016, 01:42 PM
  2. Replies: 6
    Last Post: 09-29-2015, 08:44 PM
  3. [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
  4. [SOLVED] Pivot Table - Grand Total (Row)
    By stephboucher in forum Excel General
    Replies: 3
    Last Post: 04-25-2012, 09:01 AM
  5. Pivot Table - Sub Total & Grand Total Filter
    By ramki in forum Excel General
    Replies: 1
    Last Post: 08-07-2009, 11:40 PM
  6. [SOLVED] Pivot Table - Grand Total for Rows
    By Joe in forum Excel General
    Replies: 3
    Last Post: 05-30-2006, 07:10 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