Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can someone tell how this expression works
Sum(Aggr(Sum(TOTAL <Store, Market> SalesUnits), Store, ProdName, Market))?
Did you pick this expression from here?
Evaluate Chart Expression at line level
I did attach a sample. Did you try looking into it?
Did you pick this expression from here?
Evaluate Chart Expression at line level
I did attach a sample. Did you try looking into it?
Yes but could you explain how this expression works ?
Thanks.
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
I also suggest reading this: