using percentages in pivot table group function

[theDrew]

Hello everybody!

In a pivot table, I am reporting the results of a survey question "What percentage of potential business is lost to ...xxxxxxx" and the respondent answers with a percentage. Since it is an open response that can have up to 100 different answers, I chose to use the Group function to show the responses 0-10%, 11-20%, etc. Unfortunately Excel lables the groups 0-0.1, 0.1-0.2, 0.2-0.3, etc. I have toyed with the pivot table and field properties for hours but can't get the pivot table to display the results the way I want them to be displayed.

Tips?

 

[Mark W.]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Field1	Field2		CountofField1
2	5%	0-10%		Field2	Total
3	14%	11-20%		0-10%	1
4	22%	21-30%		11-20%	3
5	45%	41-50%		21-30%	2
6	33%	31-40%		31-40%	2
7	11%	11-20%		41-50%	2
8	28%	21-30%		GrandTotal	10
9	20%	11-20%
10	49%	41-50%
11	34%	31-40%
12
13
Sheet1

 

[theDrew]

thanks mark that works!!

 

[PaddyD]

"I chose to use the Group function to show the responses 0-10%, 11-20%, etc."

You could also consider the histogram function that's part of the anaylsis tool pack.