Matrix table with columns grouped by quarter

[Anonymous]

Hello,

I have a table I'm trying to replicate that looks like this:

A, B, C are just values under 3 columns, like category, sub-category and concept respectively. I assume this can be done with a matrix, but I still don't know how to group the columns actual, target and forecast by quarters and to have them shown at all times.

This is how my data is organized:

Column1  Column 2 Column 3 Quarter Actual Target Forecast

     A              B               C              Q1         X        X          X

     A              B               C              Q2         X        X          X

     A              B               C              Q3         X        X          X

     A              B               C              Q4         X        X          X

     A              B               D              Q1         X        X          X

     A              B               D              Q2         X        X          X

The first 3 columns would go to the rows, that's why I understand, but I don't know how to put actual, target and forecast below quarters, is it possible to do or what do you recommend? Those % columns in the image are done easily with calculated columns, that's why I don't mention them.

I'd appreciate some help, TIA.

[Icey · Accepted solution]

Hi @Anonymous ,

Try this:

BTW, .pbix file attached.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.