• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

How to get text field to display correctly in pivot table?

Hello - I've got a Excel 2010 pivot table that displays several percentage amounts (displayed as numbers with 2 decimal places, not with "%" signs), and in the middle of that, the user wants to display 2 particular percentages as a ratio, with a colon separator, like: "1.23 : 4.56"

I've tried a calculated field, but the pivot table still mashes it into a number.

Any way to get this done?

Thanks
0
mlagrange
Asked:
mlagrange
  • 2
1 Solution
 
nutschCommented:
The only way you could see that would be by turning this field into a text field, formatted the way you want it, but that would mean that you can't put it in the pivot anymore, since the data field will only take numbers.

IMO, not possible, sorry.

Thomas
0
 
mlagrangeAuthor Commented:
yep, that's all I see, when I look around out there...
ok, thanks for your help
0
 
nutschCommented:
Yep, sorry about that. You can do it by setting a static table with formulas, but pivottables do have their limitations.

Thomas
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now