+ Reply to Thread
Results 1 to 2 of 2

Totals for rows in Pivot

  1. 04-18-2018, 04:45 PM #1
    grkchakri
    grkchakri is offline
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Totals for rows in Pivot

    Hi All

    I have created pivot table. the table generates grandtotal for the columns but i am also looking for totals by rows.
    Any idea how can i do that.

    i have highlighted the area in green where i feel the totals should come up. Any suggestions
    abc.png
    Never confuse a single defeat to the final defeat.
    Reply With QuoteRegister To Reply
  2. 04-18-2018, 04:55 PM #2
    Roel Jongman
    Roel Jongman is offline
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: Totals for rows in Pivot

    while you have the pivot table selected look at the extra menu "design" that appears in there there is the option to select which totals should be shown. totals for rows and columns would be your choice
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculated field in pivot table not using cumulative totals from pivot?
    By Patstaff in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-13-2021, 03:32 AM
  2. Pivot Table Percentage of grand totals listed under the grant totals
    By Biker102 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-31-2017, 01:31 PM
  3. Totals and % of Totals under certain columns in Pivot Table
    By adrenom in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-13-2016, 02:16 PM
  4. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  5. Help: Macro Adds Rows, Need to Update Totals with New rows
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2006, 12:15 PM
  6. Help: Macro Adds Rows, Need to Update Totals with New rows
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2006, 05:40 PM
  7. Help: Macro Adds Rows, Need to Update Totals with New rows
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2006, 05:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1