Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: pivot table custom subtotal

    I have a pivot table with 3 columns, I would like to generate another pivot table by subtotalling according to the first 3 numbers in the first column.

    For example: Existing Pivot Table

    Code Description Amount
    4107100 MEDITECH SERVER SUPPLIES $255.00
    4109200 OFFICE SUPPLIES $22,973.68
    4109210 OFFICE EQUIP<$500 $22,766.42
    4150000 HSKPG SUPPLIES COMB $9,272.77
    4151000 DISP PAPER SUPPLIES $11,991.61
    4152000 CLEANING AGENTS $22,431.00
    4200000 LAUN.SUPPL.COMBINED $326.12
    4201000 DETERGENTS/SOAPS ETC $19,908.22

    I would like to subtotal by the first 3 digits. End result would look like:

    Code Amount
    410 $45995.0996
    415 $43695.377
    420 $20234.34

    If anyone has any ideas/code it's greatly appreciated.

  2. #2
    Join Date
    Jul 2003
    Posts
    7
    just an idea no expert here, but would you be able to use the left function to seperate out the first 3 characters of code in the table.

    if would be like =left(b2,3)
    this assuming that code starts at b2 and just drag down. This would provide you with an extra field that would have to be named. but it could be used in the page field property of your pivot table or dragged around the pivot table to whatever view you would like

  3. #3
    Join Date
    Jul 2003
    Posts
    7
    forgot to attach this file without macros
    Attached Files Attached Files

  4. #4
    Join Date
    Feb 2004
    Posts
    2
    Thanks for that idea and the example - great I'll use it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •