Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
)
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
)