10 Replies Latest reply: Jul 25, 2013 6:18 PM by Aji Paul RSS

    Question on AGGR dimension total

      Hi All,

       

       

      I have a simple but complex requirement.

       

      In teh table below I have "# In group" is a calculated dimension based on Group and sub group.

       

      Is there any way I could add a total at "Group level" and Total level?

       

      Thought of converting it to expression, in that scenario it repeats for every year. (is there any way to make an expression independent?)

      TotalOnDimension.png

       

      Thanks in advance,

      Aji Paul.