Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI -
I am trying to aggregate/display my data by two dimensions
Dimension 1 - Location
Dimension 2 -Region
Here is an example of my expression:
Fabs(Sum(Aggr(Sum(Data),[Location])))& Fabs(Sum(Aggr(Sum(Data),[Region])))/100
What am I doing wrong?
Thank you
Zhenya
Hi.
It depends on what you're trying to achieve 😃
Where do you use this expression ?
I am using this as part of my cross tab table.
I want my table to display values that are only relevant to Location & region.
Why not just Fabs(Sum(Data)) ?
When i do that all values disappear from my table.
It seems your data model differs from the one I've imagined.
Could you attach a screenshot with it?
I mean Table viewer (Ctrl+T) screen shoot.