How do i automatically group rows in a pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table with a long set of rows (>200). I'd like to group them
into 10 groups, almost like a histogram. Is there a way to do this? The only
group function appears to be manual. And I don't see any way of doing it
using the show-top-X summarization feature.
 
You could select multiple rows with the mouse, right-mouse-click an
then 'group'. then over-type a description for that group.

You could also use a vlookup or equivalent to populate a helper colum
with labels that you can group by.

regards.
 
Back
Top