Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you group data in a Pivot Table?
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you group data in a Pivot Table?
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. -- Regards Roger Govier "rhianna" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to group a pivot table | Excel Discussion (Misc queries) | |||
Why does the pivot table not allow me to group data? | Excel Discussion (Misc queries) | |||
Pivot table/chart - can I use data ranges? why will it not group d | Charts and Charting in Excel | |||
Pivot Table - no group on web | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |