How do i automatically group rows in a pivot table?

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.
 
S

steven1001

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table help 5
Pivot Table - Controlling how many rows of data are displayed in t 1
Grand Total for Rows not Working in a Pivot Table 1
Pivot Table Charts - Help Required 1
Pivot Table - 3
Group in Multiple Pivot table 1
Unable to Group in Pivot Table 1

Top