How make this sum

[#1]

Hello.

Can i have help please.

I want to make the sum of NBTEU for each REFCONT.

The sum must be 2 because i have two different  REFCONT.

How can i do it.

Best's regads

[anbu1984 · Accepted solution]

Add REFCONT as dimension

[#3]

How can i do it, please?

[tresesco]

Try like:

=Sum( Aggr( sum( DISTINCT NBTEU),REFCONT))

[its_anandrjs]

Hi,

Try with this

=Sum( Aggr( Sum(DISTINCT  NBTEU ), REFCONT ) )

And aggregate the rows in the expression no need to add the dimension.

Anand

[anbu1984]

You don't need to add dimension. Use Tresesco's suggestion below

[its_anandrjs]

Hi Destin,

I think your requirement is without the dimension then try to write like

=Sum( Aggr( Sum(DISTINCT  NBTEU ), REFCONT ) )

Tresesco and i suggest other wise add the dimension in the chart, also try do not use dimension in the gauge chart.

Regards

Anand