Numerator as one row by Denominator the whole column

[Anonymous]

Hi GuYS

What's the best way to do in a KPI where i want to take each value from one dimension as the Numerator divided by all the vales in that column as the Denominator? Is it best to do in the script or expression and how?

Regards

[Anonymous]

Could you explore more with some sample data??

[sunny_talwar]

Are you trying to do something like this:

Dim1     Val

A          10

B          15

C          25

and in the KPI you are trying to do for A -> 10/50?

For this you can try Sum({<Dim1 = {A}>}Val)/Sum(Val)

If this isn't what you are looking for, please elaborate on what you are looking to do.

Best,

Sunny

[Anonymous]

like this?

[Anonymous]

I guess, he is asking for Val=10 as Numerator and sum(Val)=50 as Denominator...

If yes, try with total:

sum(Val)/sum(total Val)

[simondachstr]

sum(Column)/sum(total Column) ?

[sunny_talwar]

Thanks for pointing that out Balraj. The expression was suppose to do 10/50, but I mistakenly wrote 10/25

[Anonymous]

Thanks guys, i just need to test something else before i can test this as it's not as straight forward as i've posted, i'll elaborate later.

[Anonymous]

It seems, you were playing with us