+ 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
    Excel 2010
    Posts
    392

    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
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    862

    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
    Excel 2010
    Posts
    392

    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
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    862

    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)

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