When creating pivot tables (based on an Analysis Services data source) all
the sub-totals seemed to be forced to the right. Is there any way to have a
sub-total appear immediately after it's group? For example in the dumb
mock-up below, there is a customer dimension on the y axis, and a
dimension(quarter) and measures (revenue by month) on the x axis. I would
like the sub-total of Q1 (monthly revenue) to be positioned immediately after
the last month from Q1 and before the first month of Q2.

Q1 Q2 TOT-Q1
TOT-Q2 TOTAL
CUSTOMER MONTHLYREVENUE
1 2 ... 1 2
John Doe 5000 2000 1000 2500 7000 3500
10500
Jane Doe 2000 3000 3000 4000 5000 7000
12000


Any help/advice would be appreciated.