Format a Calculated Field in Pivot Table

T

tcalleia

New Member
Joined
Feb 7, 2008
Messages
36
I need to format a pivot table calculated field to a %. When I right click on the field name and go to field settings the "number" option is not listed as it is on the other fields. I can manually format the whole column but then whenever I refresh the pivot table it reverts back to a #. Is there any fix for this?
Thanks:)
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
You should be able to format it exactly the same as other fields. Which version of Excel are you using?
 
Upvote 0
2003- Is that my problem?

When I click field settings on other fields I see the buttons: OK, Cancel, Hide, Advanced, Layout, & Number on the right side. When I click field settings on the calculated field I see: OK, Cancel, Hide, Advanced, and Layout(which is grayed out). Number does not appear at all:(
 
Upvote 0
To me that would imply that it is a row or column field that you are clicking, not a data field.
 
Upvote 0
Then the pivot table is treating it as text. What is the formula you are using?
 
Upvote 0
I'm using Profit/Sales to get Margin%

Profit and Sales are row fields- not data fields. Is that where my problem might be?

Thanks:)
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Calculated Field in pivot table difficulty
Replies
2
Views
300
bluefish44
B
B
  • Question
Calculated Field Coming Back as Zero
Replies
4
Views
299
biotbravo
B
A
  • Question
Calculated Pivot Table Field
Replies
1
Views
454
RoryA
RoryA
H
  • Question
Make an slicer in vba excel automatically
Replies
1
Views
94
Domenic
D
S
  • Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
164
sschaefer
S

Forum statistics

Threads
1,214,918
Messages
6,122,243
Members
449,075
Latest member
staticfluids

Share this page

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
Back
Top