+ Reply to Thread
Results 1 to 4 of 4

Additional SubTotals in Pivot needed

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    VA
    MS-Off Ver
    2010
    Posts
    2

    Additional SubTotals in Pivot needed

    I'm sure I can figure this out with a helper column or something in my source data but I'm running out of time so I need someone to just tell me how to do this...

    Here is what I have:
    2014-06-18 08_38_18-Microsoft Excel - FY15 Full Truckload Analysis TEST.xlsx.png


    Here is what I want:

    2014-06-18 08_37_09-Microsoft Excel - FY15 Full Truckload Analysis TEST.xlsx.png



    Notice the subtotal for the In/Out of region....I have multiple Ship Froms and want this for each one.

    Thanks in advance for your help!

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: Additional SubTotals in Pivot needed

    Move that field one to the left then it's easy. Otherwise you can only have a grand total for In/Out, not a subtotal at the level of 'Ship From'.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    06-18-2014
    Location
    VA
    MS-Off Ver
    2010
    Posts
    2

    Re: Additional SubTotals in Pivot needed

    Thanks for the suggestion but that's not what I'm looking for. I'm looking to keep the region subtotals together at the bottom directly above the grand total.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: Additional SubTotals in Pivot needed

    Then I'm afraid you're out of luck. If you want subtotals out of order with the field order, you can only get an overall grand total for a field, so you have to have region to the left of 'ShipTo'.

+ 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] Nested Formula - Additional Help needed
    By jealkon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2012, 02:56 PM
  2. Replies: 1
    Last Post: 01-13-2010, 09:04 AM
  3. Adding Additional Functions to Subtotals in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-27-2007, 09:14 AM
  4. Additional Columns Needed
    By amiestephenson in forum Excel General
    Replies: 1
    Last Post: 06-08-2007, 09:29 PM
  5. Pivot table subtotals help needed
    By anthony in forum Excel General
    Replies: 3
    Last Post: 04-26-2005, 08:06 AM

Tags for this Thread

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