Re: How do you group data in a Pivot Table?
- From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 28 Mar 2007 01:20:02 +0100
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" <rhianna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7902F632-55D0-4BB8-8054-F5AF143C88E8@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: RE: Copy/Pasting formulas
- Next by Date: RE: Copy/Pasting formulas
- Previous by thread: RE: Copy/Pasting formulas
- Next by thread: Which is faster sum(if) as an array or sumproduct?
- Index(es):
Relevant Pages
|
