Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to add real dimensions (standard fields) in a synthetic dimension pivot table?
If I have a table like this...
dim (valuelist)
A
B
C
and expression (pick/match) $(calcA), $(calcB),$(calcC).
Is is possible to add a standard secondary dimension that only related to dim B ($calcB)?
Hi
You can create the dummy field in the script by using inline load with valuelist values.
And then, add 2nd dim like below,
If(DummyField = 'B', ursecondarydimension)
hope it helps