Group By function in Expresssion

[#1]

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.

[swuehl · Accepted solution]

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

)