Pivot Table Help

[jamiedavies02]

Hi

I am after some advice/ help with a problem I am having.

Below is my pivot table;



What I would like to know is how can I add a column to the table that wokrs out what % the numbers in column E are from the corresponding numbers in column A? for example, I would like to add column G, which works out what % AE is from AA (what % 3 is of 9)

Thanks in advance

 

[Smitty]

Welcome to the Board!

The easiest thing would be to add a column in your source data, and add that to your Values field. Then change the Values field setting to Max. Otherwise, you can try a Calculated Field.

HTH

EDIT: fixed URL tags

 

[jamiedavies02]

Thanks for the reply.

I'm still really struggling. Any chance somebody could walk me through? Should add column b is not part of my source data, thats a calcualtion

 

[Smitty]

What are you struggling with? You can always upload your workbook to a file sharing site like OneDrive, then post the link back here. Just make sure to remove any sensitive personal/company information and give us just sample data.

Should add column b is not part of my source data, thats a calcualtion

That shouldn't matter - You can create a calculation based on another one.

 

[jamiedavies02]

I can't add a column to do the calculation that I want, I want to show column E as a "% of" column A, but when I try to do this column A isn't an option as a base field/ item

 

[Smitty]

Then you'll need to add the column in your raw data.