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

retrieve data from a date formated cell

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


Joined: 18 Aug 2006
Posts: 15

PostPosted: Thu Aug 30, 2007 8:35 pm    Post subject: retrieve data from a date formated cell Reply with quote

i have a row with date formatted like dd/mm/yyyy, i would like to use the datapilot to draw some data but how can i sum up the total for each month for the entire row? any dieas?
cheers,

ahdont
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 Aug 30, 2007 8:52 pm    Post subject: Reply with quote

ahdont:

You asked:
ahdont wrote:
i would like to use the datapilot to draw some data but how can i sum up the total for each month for the entire row


Please check the post below . . . with emphasis on using grouping data. That is, after you have created your DataPilot,

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
3. Press OK

http://www.oooforum.org/forum/viewtopic.phtml?t=50856

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

Sliderule
Back to top
View user's profile Send private message
wibble
General User
General User


Joined: 29 Aug 2007
Posts: 6

PostPosted: Thu Aug 30, 2007 11:45 pm    Post subject: Reply with quote

Sliderule wrote:
ahdont:

You asked:
ahdont wrote:
i would like to use the datapilot to draw some data but how can i sum up the total for each month for the entire row


Please check the post below . . . with emphasis on using grouping data. That is, after you have created your DataPilot,

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
3. Press OK

http://www.oooforum.org/forum/viewtopic.phtml?t=50856

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

Sliderule



.......... and Laughing why would you Laughing consider yourself as an advocate of OOo? LaughingLaughingLaughing
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