I need help is making selections in a calculated dimension, it goes something like this.
Calc Dim = If(Dim3='A',Dim1, Dim2)
This is a part of my table. If someone makes a selection in this dimension, then all 3 dimension get selected but I want either Dim1 or Dim2 to select and not the others. Is this possible?
When you make a selection from a calculated dimension, you are actually making a selection in the underlying fields. Much the same way as selecting an expression value in a straight table selects the dimensions underlying the selected expression value.
If possible, use this logic to create a derived field in the load script.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
