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

      Hello,

       

      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,

      Regards,