How do you group data in a Pivot Table?

G

Guest

Sorry, this is a really basic question but I'm only new to Pivot tables.
I am trying to calculate the frequency of some data and I have some ages in
a pivot table that i want to group but when I click "group" another column
with the heading "Group1" appears with no data in it.
I have grouped data once before but I can't remember how to do it properly
 
R

Roger Govier

Hi

Select the field you want to group, and from the PT Toolbar select
group.
The dialogue box should open with the highest and lowest value of your
range.
Select the range interval you wish to group by.
 

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

Unable to Group in Pivot Table 1
Pivot Tables with different groupings based on same data table 2
Pivot Table Question 3
Query on Group field in Pivot Table 4
Excel Pivot Table 4
Excel Pivot Tables 1
Pivot Table sort 2
Pivot Table Help! 1

Top