+ Reply to Thread
Results 1 to 6 of 6

Subtotal within pivot table

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-27-2009
    Location
    San Diego California
    MS-Off Ver
    Excel 2010
    Posts
    160

    Subtotal within pivot table

    Using Windows 7 and Office 2010 I have tried to upload the workbook example for this thread, it won't work, is 21.9 MB too large a file to upload here?
    I would like to subtotal with each plant # change in a pivot a maximum odometer column and a minimum odometer column to show total miles driven by each truck at each plant for each month in a year.
    I can show the max/min calculation outside the pivot table, but cannot reference the change in plant number from within the pivot table to subtotal by plant #.
    I have tried to insert calculated fields but cannot understand the only example I could find.
    Can anyone help with the explanation above without an example workbook?
    Thanks

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Subtotal within pivot table

    Can you not post an example so we know the structure? Just post 5 example components for instance.

  3. #3
    Forum Contributor
    Join Date
    10-27-2009
    Location
    San Diego California
    MS-Off Ver
    Excel 2010
    Posts
    160

    Re: Subtotal within pivot table

    I have an example ready to go at 440 KB, well within the upload limit.
    No joy, can't find anything evident on how to troubleshoot the upload failure.
    Can anyone help?

  4. #4
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Subtotal within pivot table

    Sometimes I have to click the attachment button twice. What browser are you using?

  5. #5
    Forum Contributor
    Join Date
    10-27-2009
    Location
    San Diego California
    MS-Off Ver
    Excel 2010
    Posts
    160

    Re: Subtotal within pivot table

    Version 9.0.8112.16421 update 9.0.4
    I'll try the attachment button twice, thanks

  6. #6
    Forum Contributor
    Join Date
    10-27-2009
    Location
    San Diego California
    MS-Off Ver
    Excel 2010
    Posts
    160

    Re: Subtotal within pivot table

    No joy, all I see is the working in background spin for a couple of seconds and nothing is uploaded.
    How do I get rid of all the attachments I do not want anymore?

+ 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