Grouping Pivot Table Data

R

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%
Click to expand...
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
 
Top