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

    Group By function in Expresssion

      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.




        • 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:



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