Hi, I am trying to group certain values together in my pivot table so that when i create the pivot chart all values with the quantity of "1" can be under "Other". So essentially i would only have 5 bars: Apple, Banana, Cherry, Blackberry, Other. When i try to group it say "That selection cannot be grouped". I tried to change the values and rows/columns but get the same message. I have attached a sample document.
Any help would be appreciated.
Bookmarks