ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Position Totals immediately after a subgroup (https://www.excelbanter.com/excel-discussion-misc-queries/183934-how-position-totals-immediately-after-subgroup.html)

boston_sql92[_2_]

How to Position Totals immediately after a subgroup
 
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.


All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com