How to Position Totals immediately after a subgroup

B

boston_sql92

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mutiple conditions formula to assign segmentations and coverage 0
Using Excel to keep a track of moving tasks/costs 6
formula patterns with a gap of two 0
How to retain sub-totals after refresh 0
How to Link to the next blank row after the last entry in a column? 1
VB Script or Macro To Remove a row after it's copied to another sheet 0

Top