Custom Column(s)

[Anonymous]

Hi All

Below is Pivot table requirement

Here GTB, AWM and CBS are Dimension, when 3Q14, 4Q14 ...4Q15 are expressions.

valuelist('Actual', 'FRB B') created

Normally what happen all six expression (3Q14, 4Q14 ...4Q15) pop up for Actual and FRB B. I want exactly as above.

Under 3Q14 expression I applied condition if(valuelist('Actual', 'FRB B') = 'Actual', 0,1) still not work

How do I create custom column as Expression.

Thanking you

[Anonymous · Accepted solution]

Finally achieved. Created all custom dimensions and only one conditinal expression.

Thanks for your time