Data aggregation in Expression

[#1]

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

[whiteline]

Hi.

It depends on what you're trying to achieve 😃

Where do you use this expression ?

[#3]

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.

[whiteline]

Why not just Fabs(Sum(Data)) ?

[#5]

When i do that all values disappear from my table.

[whiteline]

It seems  your data model differs from the one I've imagined.

Could you attach a screenshot with it?

[#7]

[whiteline]

I mean Table viewer (Ctrl+T) screen shoot.