Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Hi there,
Try:
Sum(Aggr(sum([Est Cost/Budget]),[Program]))
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