Manipulating Pivot Table Data - % of Column

ET Hug

Board Regular
Joined
Jun 3, 2005
Messages
111
Hi Everyone,

I've created a Pivot Table and added a % of Column to the data area. I don't want this shown as a percentage, but rather as the percentage value multiplied by a 100. How would I change the values that are in my columns to show this? Is this possible?

Thanks
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
Select the pivot item, click on the Pivot Table drop down from the pivot table toolbar, select Formulas | Calculated Field. Select the formula box, type in your formula, using the field names (listed below) you wish to change, when done click the Modify button, Ok-out.

Is this what you're looking for?
 

ET Hug

Board Regular
Joined
Jun 3, 2005
Messages
111
Hi Firefytr,

I tried that method you wrote abobe before...but the field I want changed isn't showing up as one of the fields I can manipulate.

The field I wanted changed is a column I put into the data area of my Pivot Table... then through Field Settings > Options...I changed this to show as a "% of Column". The number I'm getting is fine...but I need it mulitplied by 100 rather than showing up as a decimal or percentage. From your experience is this possible?

Thanks
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
You need to add a Calculated Field then in place of the data, then show your calculated field instead of the data field. Format as desired.

Note the calculated field cannot have the same name as your field/data name.
 

ET Hug

Board Regular
Joined
Jun 3, 2005
Messages
111
Forget it...I don't think its going to work.

Thank you Firefytr
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
Oh it will work, trust me. You just need to add your own Calculated Field. If it is it's own field with none others associated with it, just perform the custom calculation on that field.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,620
Messages
5,832,734
Members
430,160
Latest member
a_majda

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top