Pivot table and percentage of row

**qaiztan** · 10-19-2012, 09:30 AM

Hello, is it possible to compute a percentage from a pivot value?

I have below raw data.

Name Tickets Correct ticket? (1 as yes)
JOHN 1 1
HOLLIE 1 1
JOHN 1
JOHN 1 1
HOLLIE 1
JESSICA 1 1
DEANDRE 1 1
JESSICA 1 1
DEANDRE 1 1

Capture.JPG

I was able to generate attached pivot. But I need to get the percentage of correct ticket from the total ticket. Is that possible? See attached excel file.

Grateful for any feedback.

**shadrack** · 10-19-2012, 10:11 AM

See attached file

PivotSH.xls

**qaiztan** · 05-05-2017, 04:00 AM

Hello, Still having issue back in 2012. Answer is not correct in the thread! Please please help!

**JeteMc** · 05-05-2017, 09:53 AM

I believe that what you are looking for is a calculated field with the formula =Correct /Tickets, as shown in the attached file. Take a look at the second post in this thread to find out how to access them in the 2003 version.
Another way to get the percentages shown in the highlighted portion of column F is to type =D18/C18 into cell F18 then copy down.
Let us know if you have any questions.