Not able to aggregate the data

[md_anasabbasi]

Hi All,

    I came across the following set of data and I am confused how to actually calculate(write the expression)-

Account	Address	Structures	amount
abc	143 east street	2	1254
abc	143 east street	2	1257
abc	143 east street	2	45689
abc	124 wing	1	7895
abc	124 wing	1	475
abc	124 wing	1	3587
abc	124 wing	1	454
abc	12 ertsd	5	4585
abc	12 ertsd	5	75412
xyz	134 hinjew	1	4546
xyz	134 hinjew	1	58794
xyz	134 hinjew	1	451642
xyz	85,E blue	4	121
xyz	85,E blue	4	124578

   I have a text object which should show total structures-

If account 'abc' is selected so total structures=2+1+5=8

How should i write the expression for this, need help.

Thanks

[OmarBenSalem]

maybe, sum(distinct Structures) ?

[trdandamudi]

One way is as below:

[Ralf_Heukäufer]

Hello Anas,

try

aggr(sum(Structures),Structures)

or

sum(aggr(Structures,Structures))

I'am not exactly shure which of both works

[Mark_Little]

Hi,

The above example will work on selection.

But if you want it say on a chart

Use

=SUM(AGGR(ONLY(Structures),Address))

Mark

[OmarBenSalem]

sum(distinct Structures) would do it; why complicate things?