I have this calculated dimension.
Basically,when a user makes selections on MyLv16, i would like to show MyLvl6Directs values
if they selected MyLv15,Then MyLvl5Directs
I was able to confirm that,Its showing the right values from right columns.
But when a selection is made, search bar gets messed up displaying all columns in the calculated dimension.
Example,If i select values from MyLvl4Directs , It selects all the dimensions as filter selctions in the selection bar.
Am i doing something wrong here ? Any suggestions please?
=
If(GetFIELDSelections(MyLv16)>1,
MyLvl6Directs,
If(GetFIELDSelections(MyLv15)>1,
MyLvl5Directs,
If(GetFIELDSelections(MyLv14)>1,
MyLvl4Directs,
If(GetFIELDSelections(MyLv13)>1,
MyLvl3Directs,
If(GetFIELDSelections(MyLv12)>1,
MyLvl2Directs,
If(GetFIELDSelections(MyLvl1)>1,
MyLvl1Directs,
[Directs Only]
)
)
)
)
)
)
