+ Reply to Thread
Results 1 to 4 of 4

Pivot table (Total for Row not showing)

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Pivot table (Total for Row not showing)

    Hi, can someone help to see whats wrong with my pivot? I have click n Total for Row. But its not showing.
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Pivot table (Total for Row not showing)

    Your row values are discrete Data Fields... to a get a total of the 4 data fields either

    a) create a Calculated Field in your Pivot, or (simpler)
    b) add a Total column to your underlying Table, refresh the Pivot, add the new Field as a further Data Field

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Re: Pivot table (Total for Row not showing)

    Quote Originally Posted by XLent View Post
    Your row values are discrete Data Fields... to a get a total of the 4 data fields either

    a) create a Calculated Field in your Pivot, or (simpler)
    b) add a Total column to your underlying Table, refresh the Pivot, add the new Field as a further Data Field
    Hi. Can u show me how its being done? Whats a calculated field?

  4. #4
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Pivot table (Total for Row not showing)

    I would suggest having a look at the following:

    https://www.contextures.com/excel-pi...ted-field.html

    If you use Pivot Tables a lot, or are learning them, Debra Dalgleish's website will prove to be a great reference point.

+ 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. Pivot table not showing total
    By devawad in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-05-2018, 09:59 PM
  2. grand total on row not showing - pivot table
    By jw01 in forum Excel General
    Replies: 1
    Last Post: 07-13-2017, 05:31 PM
  3. Replies: 1
    Last Post: 07-29-2016, 04:30 PM
  4. [SOLVED] pivot showing 0 in sub total row not negative value
    By wacky_diva in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2015, 03:11 AM
  5. Pivot showing percentage in Grand total grouped by first column
    By matpj in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-16-2014, 09:47 AM
  6. Pivot table report, one column NOT showing the total
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2011, 08:14 PM
  7. Grand Total on Pivot Table turned on but no totals showing
    By GaryRitchie in forum Excel General
    Replies: 0
    Last Post: 06-15-2005, 09:13 AM

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