Custom Field to Calculate Percentage

[masouder]

I have a pivot table that analyzes test results. Assume three fields: Test, Result and Failure. If a test resulted in a failure then there is 1 in this field; otherwise there is a 0. There are several test results for each test. I want to calulate the percentage of failures for each test. I have selected Test for Row Labels. I cannot figure out how to calulate the percentage. Basically, the formula equates to =SUM(Failures)/COUNTA(Test). In other words, for each test add the failures and divide by the total number of results for that test.

Any help is greatly appreciated.

[AlKey]

Hi and welcome to the forum,

I think to calculate a percentage in PivotTable all you need to do is add again the same field in Sum Values then go Value Field settings, go to Show Values As and select %Running Total in.

[masouder]

Thanks for the reply, but I don't think this works. I assume you meant to add the Failure field with the Sum operation then set Show Value As. There is no % Running Total In, but I tried Running Total In. That did not seem to work. I had already tried the various settings in Show Value As, but none seemed to work.

Any other ideas?