Hello all !
I try to know the dimension on each line in a pivot table, like this :
It looks great. Each total lines matchs with the right dimension level.
But if my table contains conditional expression for enable it, the result is (Example of add conditional expression for Market.Market1_Alias field) :
The second total line is now Market.Market2_Alias but the result of my function is Market.Market2_Alias. Unfortunately, I understand why.
Do you think there's a possibility to have :
|Market.Market_Alias ||Market.Market2_Alias ||=Dimensionality()||=GetObjectField(Dimensionality()) |
|Total ||1 ||Market.Market2_Alias |
|Total ||0 ||Market.Market_Alias|
Thanks in advance for your help !