Expression working

[#1]

can someone tell how this expression works

Sum(Aggr(Sum(TOTAL <Store, Market> SalesUnits), Store, ProdName, Market))?

[sunny_talwar · Accepted solution]

Did you pick this expression from here?

Evaluate Chart Expression at line level‌

I did attach a sample. Did you try looking into it?

[#3]

Yes but could you explain how this expression works ?

Thanks.

[sunny_talwar]

If you create a straight table using the Aggr() dimensions and this (Sum(TOTAL <Store, Market> SalesUnits)) as expression, you will see this

Basically, it is totaling at Market and Store level. Read about The Aggregation Scope here.

Once you have this, I am just summing these values for Each ProdName. For instance Prod_A appears twice.

1000 + 3400 = 4400

Does this help?

Best,

Sunny

[sunny_talwar]

I also suggest reading this:

What does the TOTAL qualifier do?