Trying to do a % of another column in pivot table but it just gives N/A's.

**SuCCB29** · 02-22-2024, 10:31 AM

Hi,

I am trying to do a % of a column in a pivot on excel. I tried to do this by right clicking on the cell in the pivot table, then 'show values as', 'more options', '% of'. When I have tried to do this it brings through N/A's and does not do a % of.

I have inserted a picture so you can see what I was trying to do. I am trying to do column 'F' as a % of column 'C'.

Is somebody able to assist please?

**Pepe Le Mokko** · 02-23-2024, 03:05 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**SuCCB29** · 02-26-2024, 01:00 PM

Hi,

I have attached the copy of the pivot. I have stated how I have tried to do column E of C as s %.

**rorya** · 02-26-2024, 05:43 PM

You just need a calculated field dividing one field by the other, then format as a percentage. See attached.

**DJunqueira** · 02-26-2024, 06:02 PM

And if you want to transform the #DIV/0! erro into 0 use the formula bellow.

=IFERROR('Variance Qty'/'BOM Requirement with Scrap %',0)

**rorya** · 02-27-2024, 05:59 AM

Or you can use the pivot table options to display whatever you like for errors.

Trying to do a % of another column in pivot table but it just gives N/A's.

LinkBack

Thread Tools

Rate This Thread

Display

Trying to do a % of another column in pivot table but it just gives N/A's.

Re: Trying to do a % of another column in pivot table but it just gives N/A's.

Re: Trying to do a % of another column in pivot table but it just gives N/A's.

Re: Trying to do a % of another column in pivot table but it just gives N/A's.

Re: Trying to do a % of another column in pivot table but it just gives N/A's.

Re: Trying to do a % of another column in pivot table but it just gives N/A's.

Thread Information

Users Browsing this Thread

Similar Threads

Divide Avg Pivot Table Column by Avg Pivot Table Column

Add custom column to Pivot Table or update Source data FROM pivot table

[SOLVED] Use Power Pivot (DAX) or Pivot Table (New Measure) to sum all values for specific column

Table to column problem to create dataset for pivot table [Bloomberg data to pivot table]

Format a pivot table based on values of a pivot column

Changing a pivot chart column color based on the pivot table category

Bookmarks

Bookmarks

Posting Permissions