Pivot Tables and Groupings

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

Hello,

I have exported data from MS Project into Excel and I have created a
pivot table. Within the table there are a variety of percents. I want
to group them into ranges. ie. 0-25%, 26-50% etc. I have searched
within excel regarding groupings. I am told that I can right click on
the field and start box will come up in which you can put in the
numeric value. However, the only way it will let me group is if I
highlight some groups that I want to group and then right click and
select group. However, this does not continue down for other
sections.The box to input a value is not displayed. I have also tried
changing the text format....but there is no change.

I would like to be able to update the data on the excel spreadsheet
and have the pivot table update with the ranges so I can give it to
management.

Any help would be greatly appreciated.

Thanks.

Linnea
 
You could create a lookup table (named PercentGroup in this example) in
the workbook,

0 0-25%
0.25 26-50%
0.5 51-75%
0.75 76-100%

Then add a column to the data table, in which you look up the grouping.
For example, with percentages in column F:

=VLOOKUP(F2,PercentGroup,2)

Add this field to the row or column area of the pivot table.
 
Back
Top