Second dimension (real) in a table with synthetic dimensions

[pedromsouza]

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)?

[MayilVahanan]

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