View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
rhianna rhianna is offline
external usenet poster
 
Posts: 1
Default 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