Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a list box(Dim1),and one straight table dimension for straight table(X_Dim).
values:
Dim1
X
Y
Z
in straight table dimennsion(X_Dim) it should dim1 values it means that what I ever I select in Dim1 and then for X_Dim label should be same.
ex:
If I select X in Dim1 and label will be X for X_Dim(Straight table Dimension)
=only({$ <Dim1*={x,y}>} Dim1)
Not entirely sure what you are trying to do. Can you share some numerical sample data with expected output?
Hi Sunny,
Label name should change what I ever I select in my list box.
Ex:
Dim1
X
Y
Z
And I have used one dimension: X_Dim in Chart for this name(Label) should change accordingly what ever I select in list box.
What if you use GetFieldSelections(Dim1) in your label?
Hi,
Do you mean that what selections are made on Dim1, should be displayed as the label for the dimension in the straight table?
If so, try using GetFieldSelections(Dim1) in the label
in this case other names also will come..
I need x,y values only,
Dim1:
X
Y
Z
Z is for another Dimension in Straight table...
If(Dim1='X', then Label name 'X',if(Dim1='Y', then Label name 'Y') like this I need label name but If(Dim1='Z', then Dimension in Straight table is different.
in this case other names also will come..
I need x,y values only,
Dim1:
X
Y
Z
Z is for another Dimension in Straight table...
If(Dim1='X', then Label name 'X',if(Dim1='Y', then Label name 'Y') like this I need label name but If(Dim1='Z', then Dimension in Straight table is different.
Priya I am not very sure what you are trying to say. If Dim1 = 'Z' then what would be the label??
See this example