Grouping Pivot Table Data

[Richard Massey]

Help! I am wanting to group pivot table data (Excel
2000). Easy, I know...if I want to group the data
manually (highlight area and click grouping...group).

However, my data contains %ge data. The data is to be
updated regularly as I get more and more information. I
do not want to have to re-draw the table each time.

I would like to setup some manual groups based on
percentage ranges:

= 0% <50%
=50% <60%
=60% <70%

etc.

Since I do not have these exact percentages in my data, it
could be that I am reporting my information incorrectly.

Is there a way to manually set up the grouping for a pivot
table? (without using VBA is possible).

If I have to use VBA, that is fine, but I would rather not.

Thanks,

Rich

 

[Dave Peterson]

I think I'd use a helper column in the original data:

Say the percentages are in column A.

=IF(A2<0.5,"=00<50%",IF(A2<0.6,"=50<60%",IF(A2<0.7,"=60<70%",
IF(A2<0.8,"=70<80%",IF(A2<0.9,"=80<90%","=90<100%")))))
(all one cell)

Or even this:
=IF(A2<0.5,"=00<50%","="&TEXT(FLOOR(A2,0.1)*100,"00")
&"<"&TEXT(CEILING(A2+0.00001,0.1),"00%"))
(still one cell)

And drag down. The use this category as one of your row fields(??).