• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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