I am trying to aggregate/display my data by two dimensions
Dimension 1 - Location
Dimension 2 -Region
Here is an example of my expression:
What am I doing wrong?
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.
Retrieving data ...