put measures under groups in a pivot table

[ali_hijazi]

Hello
got a pivot table with 2 dimensions and 5 measures as per the below sample:

now I'm asked to show for Mandays for example the actuals, the actuals for the previous month and the variance and these should be displayed as columns while keeping the rows Mandays, People costs, Other expenses ,....

so the labels Mandays, People Costs, Other Expenses, Direct Cost, and Total direct cost are not labels of expressions anymore but rather group label
so at the level of Direct Costs for example I need to display the actual numbers of previous month, current month, and thus the variance
Is this feasible?
can I create a dimension with the above label values and use 3 expressions with if else to check which value of the row is?

kindly advise

[BPiotrowski · Accepted solution]

Hi, @ali_hijazi 
Create dynamic dimension using valuelist

valuelist(dual('a',1),dual('b',2)...)

and in measure use if

if(valuelist(dual('a',1),dual('b',2)...) = 1,
// first measure (Mondays),
if(valuelist(dual('a',1),dual('b',2)...) = 2,
// second measure (People costs),
...))

[ali_hijazi]

yes!! this is it the ValueList 
thank you 
I totally forgot about it