Pivot Tables

[Red Lorakeet]

Before i post my question am I on the correct board to answer my question?
I've a question on pivot tables and want to make sure I'm in the correct
place.

Thanks

 

[Red Lorakeet]

Here is my question.

I have a pivot table that does what I want it to except the category field
that is a column field shows two different figures and I would like the
final column to calculate the percentage of one against the other.

For example extract of pivot table is like this:

Calls answered Calls resolved

100 50
100 100

I would like it to do a percentage calc in the final column

Like this:

Calls answered Calls resolved %

100 50 50%
100 100 100%

I've torn my hair out but can't get there.

Any pivot table experts out there please?

 

[Debra Dalgleish]

If both items are in the same field, you can create a calculated item to
show the percentage.

Select the Category field button
On the pivottable toolbar, choose PivotTable >Formulas>Calculated Item
Type a name for the formula, e.g. %Resolved
In the formula box, type your formula, e.g.
='Calls resolved'/ 'Calls answered'
Click OK
Format the new item that appears in the pivot table, to display as percent.

 

[Red Lorakeet]

Brilliant, brilliant

Been struggling with this all this morning - nearly got there before but
this is the perfect solution.

Thanks so much.

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that you got it working.