Is it possible to have 2 Sub totals within a single Dimension.
What I have is:
Date
Dispatch Area - This contains 8 Different Dispatch Areas 4 for the North & 4 for the South. So North areas start with NEOC and South areas start with SEOC
Data Fields
So what I would like to show on my data is: Where North or South is shown this will be the sub total. This needs to appear in the same column.
21/3/14 NEOC1 Data Values
21/3/14 NEOC2 Data Values
21/3/14 NEOC3 Data Values
21/3/14 NEOC4 Data Values
21/3/14 North Data Values
21/3/14 SEOC1 Data Values
21/3/14 SEOC2 Data Values
21/3/14 SEOC3 Data Values
21/3/14 SEOC4 Data Values
21/3/14 South Data Values
