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.
Thanks for the help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks, and *** Good Fortune ***