OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Grouping data

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Stabback
Newbie
Newbie


Joined: 21 Dec 2006
Posts: 2

PostPosted: Thu Dec 21, 2006 12:05 pm    Post subject: Grouping data Reply with quote

Hi there, I have a lot of data on a spreadsheet. It is set up that for every day that something happened it records a day and then how many things happened. For example:

3/21/2003 14
3/24/2003 6
3/25/2003 4
3/28/2003 3

This spreadsheet spans from 2003 to current. My problem is I wish to present the information grouped in months. Is there a function or any way to parse the spreadsheet and return the data such as

3/2003 52
4/2003 71
5/2003 47

Thanks for your help
-Josh
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Thu Dec 21, 2006 2:23 pm    Post subject: Reply with quote

Josh:

Yes, grouping data ( in your case, by year and month ) is possible within Calc.

The process involves two steps:
  1. DataPilot
  2. Outline - Group

In the first step ( DataPilot ):
  1. Select all your data, including the column names, then from the Menu:
  2. Data -> DataPilot -> Start...
  3. Drag the Date Button to the Row Fields area
  4. Drag the Item Button ( or whatever name you used in your sheet ) to the Data Fields area
  5. Click More to determine the location you want the results in ( sheet name etc )
  6. Press OK

In the second step ( Outline - Group ):
  1. Select ANY date cell . . . press F12 ( OR from the Menu: Data -> Outline -> Group... )
  2. In the Group By section . . . click Intervals, and, Months and Years
  3. Press OK

The result will be what you are looking for.

I hope this helps, please be sure to let me / us know.

Sliderule
Back to top
View user's profile Send private message
Stabback
Newbie
Newbie


Joined: 21 Dec 2006
Posts: 2

PostPosted: Thu Dec 21, 2006 5:06 pm    Post subject: Reply with quote

Thanks, thats exactly what I wanted. Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group