I need to know if this is possible.

I have bank transactions for 6 months from 5 different accounts. I can
easily dump the data and use a pivot table using row: Date, column: Account,
Field: Amount.

I would like to have an additional level of subtotals at the end of each
month. I tried grouping but didn't get far with inserting additional
subtotals. If I can't do this, I'm forced to create 6 different pivot tables
which doesn't sound efficient.

suggestions are welcome.