Is there a straight forward way to do this, including the background colours?
In SQL Server I'd get the data using something like this...
GROUP BY
Label1, Label2, MetaData1, MetaData2 WITH ROLLUP
HAVING
GROUPING(label1) = 0
AND (
(GROUPING(label2) = 0 AND GROUPING(MetaData1) = 0 AND GROUPING(MetaData2) = 0)
OR
(GROUPING(label2) = 1 AND GROUPING(MetaData1) = 1 AND GROUPING(MetaData2) = 1)
)
| Label 1 | Label 2 | MetaData1
| MetaData2 | Expression1 |
|---|
| Week1 | Run1 | Blah | De Blah | 2 |
| Week1 | Run2a | Foo | Bar | 6 |
| Week1 | Run2b | Flibble | De Bob | 4 |
| Week1 | - | - | - | 12 |
| Week2 | Run3 | Wibble | Wobble | 5 |
| Week2 | Run4 | Izzy | Busy | 3 |
| Week2 | Run5 | Ingleburt | Slapdeback | 7 |
| Week2 | - | - | - | 15 |
I do know how to get an overall summary, but not multiple sub-totals depending on the data.
(I've worked out a slightly hacky way, to get the task complete, now I'm looking to tidy things up and learn the correct way of doing things.)
Cheers,
Mat.
