Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
)
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
Try ValueList