Table with created dimensions

[#1]

    Hi,

Need to develop a straight table with dimensions I don't have in my data. I need the ones marked in yellow to be these dimensions(I don't have YYY, ZZZ, XXX, Growth as a Dimension in my data) Any suggestions?

What I did was too painful, basically I created text boxes within a container like this

This works but it gets really slow when you change any filter.

Any suggestions?

Thank you.

Adrian E

[vishsaggi]

You might want to use Pick and Match() using Island table. Like

LOAD * INLINE [

Dim

1

2

3

4

];

Your Regular Load Statements here..

Then in Straight table use like

Dim:

Pick(Match(Dim, 1, 2, 3, 4), 'XXX', 'YYY', 'ZZZ', 'Growth')

Expr:

Pick(Dim, Yourexprfor XXX,

                 YourExprfor YYY,

                 Yourexprfor ZZZ,

                 YourexprFor Growth

       )

[#3]

Thanks,

Couple of follow ups:

Here you refer to the ones marked in Blue (2016, YTD, FY, 18)? or Should I include also XXX, YYY, ZZZ, Growth?

LOAD * INLINE [

Dim

1

2

3

4

];

In this, as Calculated Dimension?

Dim:

Pick(Match(Dim, 1, 2, 3, 4), 'XXX', 'YYY', 'ZZZ', 'Growth')

Thank you

[techvarun]

Try ValueList

valuelist and valueloop functions