Problem with simple Aggr

[PabloOrtiz]

Hello, the situation is as follows:

I have a data table "Datos" and i need to get a table like this "Coste Servicio / Contrato"

This would be added by "Contrato" and get a table like this

C1   S1  5000  8000

C1   S2  1000  8000

C1   S3  2000  8000

C2   S1  1000  3000

C2   S2  2000  3000

I am using the following expression "sum(Aggr(sum(Coste), Contrato))" for "CosteContrato" but I can not get the same value in each row of "Contrato"

I attach an example.

Thenks.

[asgardd2]

Add NoDistinct:

sum(Aggr(Nodistinct sum(Coste), Contrato))

[stabben23]

Hi,

you need to aggr on all Dimensions, like sum(Aggr(sum(Coste), Contrato, Servicio))

Sorry, to fast answer, se above!

[Chanty4u]

try

=Agg(sum(Total Coste),Contrato)

[vikasmahajan]

Why you want aggr in this case simply sum() will give you result.

Vikas

[hic · Accepted solution]

If you want to use the sum within each "Contrato" you should use

  sum(Total <Contrato> Coste)

HIC

[kkkumar82]

Hi use,

Like Sum(Total <Contrato> Coste)

it will give you the totals of the first dimension.

PFA

Kiran Kumar

[PabloOrtiz]

Thanks Henric, it works perfectly.