[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
robbyn

Joined: 29 Mar 2004
Posts: 308

 Posted: Sun Apr 30, 2006 6:31 am    Post subject: Subtotal Is it possible to have the subtotals in the new column? If not what is the best way to achieve it?_________________Robin When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6732

Posted: Sun Apr 30, 2006 11:02 am    Post subject: Re: Subtotal

 robbyn wrote: Is it possible to have the subtotals in the new column? If not what is the best way to achieve it?

Is this from another thread? I don't think we have enough info here.
_________________
jrkrideau
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
robbyn

Joined: 29 Mar 2004
Posts: 308

 Posted: Sun Apr 30, 2006 11:11 am    Post subject: I was referring to the data subtotalling function and also the subtotalling within the data pilot. I would like the results to be in a different column from the figures being added. eg: Cats 110 Dogs 200 Subtotal 310_________________Robin When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.
Super User

Joined: 03 Nov 2004
Posts: 727

 Posted: Mon May 01, 2006 10:08 am    Post subject: Try putting an IF(A1="";K1;"") formula in the first blank column. where K1 is the column with the subtotals in it. Hope someone can point out a more elegant solution._________________One of these days I'm gonna stop procrastinating.
David
Super User

Joined: 24 Oct 2003
Posts: 5668

 Posted: Mon May 01, 2006 4:02 pm    Post subject: Perhaps someone can help me here, since I'm not an accountant. What is wrong in the example given with just using a SUM or SUMIF function wherever you need it [the column of your choice]? David.
robbyn

Joined: 29 Mar 2004
Posts: 308

 Posted: Tue May 02, 2006 1:53 am    Post subject: The reason why sumif does not help is because I would want to use all the individual subtotals._________________Robin When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.
Super User

Joined: 03 Nov 2004
Posts: 727

 Posted: Tue May 02, 2006 9:00 am    Post subject: Right. The idea is to be able to pull all the subtotals out and make a new sheet of those subtotals from several different sheets. In addition they need to be inverted on the new sheet so that the subject headings go across the top of the page and all the subtotals line up under the proper heading. But that is a different problem, first it is neccessary to get the subtotals out of the column with other entries in it. Using the if formula gets a new column which can then be manipulated._________________One of these days I'm gonna stop procrastinating.
robbyn

Joined: 29 Mar 2004
Posts: 308

 Posted: Tue May 02, 2006 10:24 am    Post subject: I had a look again at what I am trying to do and thank you all for your support. As a result of your comments and concentrating just on the datapilot subtotals, I have worked out a solution: =IF(ISERROR(SEARCH("result";C14;1));0;E14) It is a nuisance having to add the iserror but it seems that search will not give a 0 if nothing is found. Instead it gives an error message. The above formula applies to a pilot with groups and one subgroup, but the principle will work on any subtotal by a table pilot as each subtotal has the automatic description of "result" in it. If there is a better way of extracting the subtotals to a new column please advise._________________Robin When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.
noranthon
Super User

Joined: 07 Jul 2005
Posts: 3318

 Posted: Tue May 02, 2006 10:16 pm    Post subject: You could instead use IF(ISNUMBER....)
robbyn

Joined: 29 Mar 2004
Posts: 308

 Posted: Wed May 03, 2006 1:43 am    Post subject: Better idea. Thanks. Robin
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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