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.

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

forgot to attach this file without macros

Thanks for that idea and the example - great I'll use it.