Combining rows into columns in qliksense pivot table

[Aspiring_Developer]

Hello All,

I have below table :-

Dimension - Category | Subdimension

1) Measure for DYOY - (Sum({<[Sub Dimension]= {'Direct Online'},Date=,Year=,MonthYear=, test={">=$(=Num(MonthStart(Max(test)))) <=$(=Num(Max(test)))"}>}Volume)
/
Sum({<[Sub Dimension]= {'Direct Online'},Date=,Year=,MonthYear=,
test={">=$(=num(monthstart(addmonths(max(test),-12)))) <=$(=num((monthend(addmonths(max(test),-12)))))"}>}Volume)) -1

Using above logic , created other 2 measure by changing values in set analysis.

My requirement is that I need to show this table in below format :-

I have attached my data file as well in this post .

Can anyone please help me ?

@hic 

[Mark_Little]

HI @Aspiring_Developer 

What is the issue you are facing? You should be able to just add the required dimensions to the table, just be aware your set analysis will limit you sub dimension you see to the one defined in the set expression