I have an Excel 2007 worksheet which has scores from a test for a number of candidates.

The headings are:
Area, QuestionNumber, QuestionSubNumber, Comments, AvailablePoints, Candidate1, Candidate2, Candidate3



Each Area can have one or more question and each question can have one or more sub question.

I created a Pivot table to give me total score per area:
Area, AvailablePoints, Candidate1Score, Candidate2Score, Candidate3Score

There is also a grand total, which shows the maximum available points for all areas as well as how the candidates scored.

This correctly aggregates the sum of each area, so I can see the AvailablePoints and what score each candidate got for each in comparison.

This works fine.

What I would like is:
1) A column beside each candidate score which shows a percentage of the AvailablePoints, such as:
Area, AvailablePoints, Candidate1Score, Candidate1Pct, Candidate2Score, Candidate2Pct, Candidate3ScoreCandidate3Pct

Effectively this is CandidateXScore / AvailablePoints * 100, where X = 1 to 3

I would also like this applied to the grand total line.

2) I would like to add an average score and an average percentage per area and in the grand total, eg:
Area, AvailablePoints, Candidate1Score, Candidate1Pct, Candidate2Score, Candidate2Pct, Candidate3ScoreCandidate3Pct, AverageScore, AveragePct


Is this all possible within Excel Pivots?

Thanks