Hi Sean,

It looks like you'll have to re-shape the data a bit.

So first pivot the data by highlighting all the measure columns and right click to select pivot:

You'll now see two new columns - Pivot Field Names and Pivot Field Values.

The Pivot Field names are contains the groups and Q period. Right click on the column and do a custom split based on the full stop to bring back the first and last columns:

Rename your columns as appropriate:

Now go into sheet one and we can start building the viz.

So we need Group and Period in the columns, then sum(value) and avg(value) in the rows:

Right click again and select Dual Axis.

Change one of the sum of values marks card into a bar:

and make sure the avg values marks type is circles. Then right click on the secondary axis and synchronise them, you can also hide the header afterwards (there's no need to have two axis which are the same):

Start changing the colours around, maybe also remove measure names from colour on the marks card.

Ultimately you should get this:

For my example in the above screenshot, I have used min(value) and avg(value). When I sum the values it seems way too high so it doesn't look right. Please let me know how this should be aggregated instead.

I've attached the workbook so that you can take a look.

Thanks,

Mavis