Link to home
Start Free TrialLog in
Avatar of gwarcher
gwarcher

asked on

Excel 2013 Pivot Table - Group options are greyed out

I have a simple pivot table that is comprised of a state filter, a number amount for donations given in the rows and I'm using a unique identifier as a value.  I am trying to get it so that I can put a range on the donation amounts so I can count who has given in the 100-250, 251-500 etc...  For some reason the grouping options on the pivot table are grayed out.  I have tried converting the field to a number and removing all rows with blank values but nothing is working.

Thanks for the help.
ASKER CERTIFIED SOLUTION
Avatar of SunBow
SunBow
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, and                                     ***   Good  Fortune   ***