0 Replies Latest reply: Apr 23, 2012 10:41 AM by Abhinav Agarwal RSS

    Using a dimension name as a reference in another dimension

    Abhinav Agarwal



      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?


      Thanks again,