View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SC
 
Posts: n/a
Default 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.