Sum without repeat

[JRamos]

Hi all!

I'm trying to create a KPI with the sum[Est Cost/Budget],  but I need to sum without repeat the program, like distinc[Program], I don't know how to use correctly the aggr format or if this is the correct function...

Could you support me?
Best regards!

[chaorenzhu]

Then how do you want to handle repeated program? In your example there are 4 records with CX727 which one do you want to use

[Thiago_Justen_]

Hi there,

Try:

Sum(Aggr(sum([Est Cost/Budget]),[Program]))

[PrashantSangle]

I think you don't required aggr().

It is repeating because, For every program you have different supplier & lever. If you add those field in table then you will get multiple row for one program

If you want to avoid repeation of program then remove supplier & lever. If you want kept the both then

add supplier & lever as measure with below expression

chart > Table

Dimension > Program

Measure > Concat(Supplier,',') > for supplier

Measure > Concat(Lever,',') > for Lever

Measure > sum([Est Cost/Budget])

Thanks & Regards,

Prashant Sangle