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:
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
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:
etc.= 0% <50%
=50% <60%
=60% <70%
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