Pivot Table - % of another column

[Carly]

In a pivot table I was wondering if there was a way of showing a value as a % of another value by using the standard functionality?

I have tried to use, Show as % of 'other field' but it then asks you for a value of that column.

Kind Regards

Carly

 

[RoryA]

You could add a calculated field dividing one by the other.

 

[Carly]

I'd thought of a calculated field, just wondered if there was any standard functionality within the pivot table.

 

[RoryA]

A calculated field is functionality within the pivot table, so I'm not sure what you mean.

 

[Carly]

I meant the 'Show values as' options in the 'Value field settings' section.

 

[RoryA]

No, that won't work for this, I'm afraid.

 

[Carly]

A calculated field it is then, thanks for your help.