Grouping on pivot table

[Wolfroolz]

I have a pivot table that i use to view utilization. Currently there is around 8000 rows. The field is a percentage with values ranging from 0 to about 4. The main values that are a concern are the ones below 1. I grouped the field in ranges from 0-1 in .1 intervals. This works great in that I have percentage ranges from 0-10, 10-20, 20-30 etc finishing in >100. However I have been asked to show 0 range by itself and then like .001 -10 etc. I thought I could just put the start value as .001 keep the end value as 1 and the interval as .1 and that would do it. However this produces very weird results and does not work at all. Does anyone know how to put 0 by itself? Am I doing something wrong? Should I be doing this a different way? Appreciate any help. Thanks.

 

[GraH]

Consider creating a 'group label' and add it to your data (could be an hardcoded (x)lookup).

Book1
	B	C	D	E	F	G	H
1	%Field	Label
2	51,32%	50-60			Row Labels	Count of %Field
3	114,46%	>100			0	6
4	71,52%	70-80			0,01-10	206
5	360,71%	>100			10-20	204
6	78,51%	70-80			10-50	193
7	217,45%	>100			20-30	176
8	234,55%	>100			30-40	199
9	0,00%	0			50-60	210
10	378,39%	>100			60-70	187
11	332,89%	>100			70-80	197
12	191,82%	>100			80-90	187
13	267,50%	>100			90-100	182
14	108,42%	>100			>100	6053
15	9,51%	0,01-10			Grand Total	8000
16	302,51%	>100
17	0,00%	0
Sheet1

Cell Formulas
Range	Formula
C2:C17	C2	=LOOKUP(B2,{0;0.0001;0.1001;0.2001;0.3001;0.4001;0.5001;0.6001;0.7001;0.8001;0.9001;1.0001},{"0";"0,01-10";"10-20";"20-30";"30-40";"10-50";"50-60";"60-70";"70-80";"80-90";"90-100";">100"})