Vielen Dank! Met vriendelijke groeten, Salutations distinguées, Kind Regards,
DRIES FEYS CORPORATE SERVICES • Specialist Software Developer On 26 March 2013 16:04, Regina Henschel <[email protected]> wrote: > Hi Dries, > > that can by a task for the pivot table. The column, which should be sum up, > goes into the "data field" in the middle and the item by which it is grouped > goes into the "row fields". In the "More" section you can determine, where > the resulting table is written. With a double click on the sum (=drill down) > you get the filtered table. > > Or you use the sheet for a database and define a query. > > If you know, which items occur, you can use all the other counting methods. > http://www.ooowiki.de/H%C3%A4ufigkeitsVerteilung > > Or you sort the rows on Column B (the items) (or let them sort > automatically, see Options in subtotal) and use Data > Subtotal. > > There are likely more ways to do it. > > Kind regards > Regina > > Dries Feys schrieb: > >> I was too fast... >> >> |--A---|----B----|----C----| >> |WH1| Item1 | 10 | >> |WH2| Item1 | 20 | >> |WH1| Item2 | 20 | >> |WH3| Item2 | 10 | >> |WH1| Item3 | 15 | >> >> Met vriendelijke groeten, Salutations distinguées, Kind Regards, >> >> DRIES FEYS >> CORPORATE SERVICES • Specialist Software Developer >> T +32 56 43 42 45 • F +32 56 43 44 46 • [email protected] >> >> TVH GROUP NV >> Brabantstraat 15 • BE-8790 WAREGEM >> T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com >> >> >> On 26 March 2013 15:26, Dries Feys <[email protected]> wrote: >>> >>> Hello, >>> >>> I received today a question about a spreadsheet I can't answer >>> immediately. Though I'm convinced this must be possible. >>> >>> We have a sheet with >>> A : stock location >>> B : item n° >>> C : quantity >>> >>> The user wants now the sum per item, preferable in another sheet with >>> the same layout, or in a automatically generated accumulated line. >>> >>> In the help I can see something about array formulas, which seems >>> interesting, but I want an automatic break per item no. >>> >>> Example >>> >>> |--A---|----B----|----C----| >>> |WH1| Item1 | 10 | >>> |WH1| Item1 | 10 | >>> |WH1| Item1 | 10 | >>> |WH1| Item1 | 10 | >>> |WH1| Item1 | 10 | >>> >>> >>> Met vriendelijke groeten, Salutations distinguées, Kind Regards, >>> >>> DRIES FEYS >>> CORPORATE SERVICES • Specialist Software Developer >> >> > > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted -- **** DISCLAIMER **** http://www.tvh.com/newen2/emaildisclaimer/default.html "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
