1 Reply Latest reply: Aug 21, 2012 9:25 AM by Stefan Wühl RSS

    Group By function in Expresssion

    Homprakash Gowda

      Hi All,

       

      I have a situation where I need to show sum of the value for nation.

       

      My fact is at ZIP level but at nation level I want sum up the data from territory level.

       

      Basically I want see the value for 'Nation Volume' column as 5000 (refer attached QVW)

       

      It would be great if any one help me on this.

       

      Thanks,

      Om.

        • Re: Group By function in Expresssion
          Stefan Wühl

          This should give you the 5000 in your total for Nation Volume:

           

          =Sum( aggr( sum(Value), Territory,Zip))

           

          Not sure what you want to see at the details level, so you may want to use a differnt expression for that dimensionality:

           

          =if(dimensionality()=0,

          Sum( aggr( sum(Value), Territory,Zip)),

          YourDetailsLevelsExpressionGoesHere

          )