Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Division Description | Branch Description | Calc Dim (Aggr) | Margin | Expression (Aggr) | Extended Price |
Division 1 | Branch 1 | $178,130,550.42 | 3.31% | $833,041.18 | |
Division 1 | Branch 2 | $178,130,550.42 | 16.92% | $14,450,580.82 | |
Division 1 | Branch 3 | $178,130,550.42 | 56.26% | $178,130,550.42 | $162,846,928.42 |
Division 2 | Branch 4 | $2,350,939.84 | 83.10% | $2,346.06 | |
Division 2 | Branch 5 | $2,350,939.84 | 45.48% | $2,350,939.84 | $2,348,593.79 |
Division 3 | Branch 6 | $67,639,081.70 | 41.05% | $923,144.17 | |
Division 3 | Branch 7 | $67,639,081.70 | -928.05% | $67,639,081.70 | $5,204,648.75 |
Division 3 | Branch 8 | $67,639,081.70 | -52.21% | $61,511,288.78 |
I figured it out on my own!
Instead of using aggr() i just used sum(total <[Division Description]> [Sum Field]).
I figured it out on my own!
Instead of using aggr() i just used sum(total <[Division Description]> [Sum Field]).
Hi Jake,
Please can you post the expression for the field - Expression (Aggr)? It will be easy to look at the expression. I am assuming that you are using...
Aggr(Sum ([Extended Price]), [Division Description])
Is this right?
Cheers - DV
Hey DV,
That is correct.
~jake~
Cool. I am glad that you have got it working.
Cheers - DV
Me Too