![]() |
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