topic Re: put measures under groups in a pivot table in App Development

put measures under groups in a pivot table

ali_hijazi — Fri, 31 Oct 2025 06:45:12 GMT

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

Re: put measures under groups in a pivot table

BPiotrowski — Fri, 31 Oct 2025 07:56:23 GMT

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),
...))

Re: put measures under groups in a pivot table

ali_hijazi — Fri, 31 Oct 2025 14:54:02 GMT

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