Hi,

I'm looking for a way to group together several related columns in a pivot table and then have the PT output a subtotal/average for that group. Please see attached sample.

GroupingPivotTables.xlsx

I'm trying to group the Jan-Hours with the Jan-Overtime and get a subtotal column out of it. However, as you can see the raw data does not have a separate column that designates whether an entry is "Jan" or "Feb", and so I fear Excel would not allow me to do what I'm trying to do, as I suspect PT's fields must be columns.

I've thought about manipulating the raw data to generate a new row if my fear above is indeed true. However my actual data is some 50k rows, and so if I were to split each row from my current format into 12 rows from Jan-Dec, I imagine my file size will increase by tenfold, and that would not be ok, and so am hoping to see if anyone has suggestions.

Thanks!