How do i automatically group rows in a pivot table?
 

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.

How do i automatically group rows in a pivot table?
 

You could select multiple rows with the mouse, right-mouse-click and
then 'group'. then over-type a description for that group.

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

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=528688