I have a table with a 2 dimensions. The first one is a hierarchic dimension (called Channel) and the second one uses an aggr and a Total function on one of the fields.
=aggr(sum([Member Count]),[Members Channel] )
[Member Channel] is one of the dimensions in the hierarchic dimension.
Now this second dimension needs to change with the first dimension.
I tried using the GetCurrentField, but its not working.
This is what i tried and didnt work.
=aggr(sum([Member Count]),GetCurrentField(Channel) )
So is it possible to call a dimension from another dimension?