% Expression

[kevbrown]

I have at pivot table that I'm looking to add a % to but it's not a forward as x/y*100. I have -

Name     Matched          Number     Matched %     Unmatched %

1             Matched          3

1             Matched          6

1             Matched          7

1             Matched          3

1             Unmatched      4

2             Matched          4

2             Matched          5

So, for Name 1 I want the % for Matched and Unmatched.  The sum for matched would be 3/(6+7+3)=18.75% but how do i do that with the fields above?

Unmatched would be 4/4=100%

[sunny_talwar · Accepted solution]

Maybe this

Sum({<Matched = {'Matched'}>} Number)/Sum({<Matched = {'Matched'}>} TOTAL <Name> Number)

[kevbrown]

Thank you

[sunny_talwar]

I had a typo in my expression... which I have fixed now... but I guess you already spotted it on your end

[kevbrown]

Yes i did but thank you anyway.