Percentage Calculation

[vanderson009]

Hello Community,

I have table like this, which is having two columns named as Name and Relationship Nps Score.

I want Percentage Calculation for Promoter and detractor.

Percentage Calculation is only Set Analysis.

Name          , Relationship Nps Score

Promoter     , 2

Detractor     , 3

Promoter     , 4

Promoter     , 6

Detractor     , 7

Promoter     , 1

Detractor     , 9

Detractor     , 10

Could you please help me for the same.

- Thanks and Regards,

Villyee

[#2]

Expression for Promoter

=sum({<Name={'Promoter'}>}[Relationship Score])

/

sum([Relationship Score])

Expression for Detractor

=sum({<Name={'Detractor'}>}[Relationship Score])

/

sum([Relationship Score])