+ Reply to Thread
Results 1 to 3 of 3

Pivot table not summing the way I want it to.

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    Vermont
    MS-Off Ver
    Excel 2007
    Posts
    7

    Pivot table not summing the way I want it to.

    Greetings, I am starting with data in attachment "pivot table 1". I'm trying to get a total for the column "RO" in attachment "pivot table 2". What am I overlooking please. pivot table 2.JPGpivot table 1.JPG

    In other words, I would like the pivot table to total the PTS-SALE-AMTS column for RO # 533222, not give me each line amount.
    Last edited by bigguy05641; 11-20-2013 at 10:53 AM. Reason: DIDN'T LIKE TITLE

  2. #2
    Registered User
    Join Date
    02-27-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    34

    Re: Pivot table not summing the way I want it to.

    Hi,

    Can you add a printscreen of the PivotTable Field List?

    If you want the total of PTS-SALE- AMTS it sould be in the Values field, and not in the row field. You also need to remove OP-Codes from row field.

    If you want the pivot to show OP-code, you should add a subtotal for the RO-column.

  3. #3
    Registered User
    Join Date
    07-02-2013
    Location
    Vermont
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Pivot table not summing the way I want it to.

    Thank you for the help, Kimrh, that helped me.

+ 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. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  2. Excel 2003 Pivot Table Woes: Please Help!
    By ryancochs in forum Excel General
    Replies: 3
    Last Post: 05-30-2012, 11:02 AM
  3. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  4. Return pivot table range...not the data table, the PIVOT TABLE!
    By Air_Cooled_Nut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 01:07 PM
  5. [SOLVED] Pivot table woes.
    By Kevin M in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2005, 09:44 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