helpcontent2/source/text/scalc/01/12050100.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3
   4 <!--***********************************************************************
   5  *
   6  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   7  *
   8  * Copyright 2008 by Sun Microsystems, Inc.
   9  *
  10  * OpenOffice.org - a multi-platform office productivity suite
  11  *
  12  * $RCSfile: 12050100.xhp,v $
  13  * $Revision: 1.6 $
  14  *
  15  * This file is part of OpenOffice.org.
  16  *
  17  * OpenOffice.org is free software: you can redistribute it and/or modify
  18  * it under the terms of the GNU Lesser General Public License version 3
  19  * only, as published by the Free Software Foundation.
  20  *
  21  * OpenOffice.org is distributed in the hope that it will be useful,
  22  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  23  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  24  * GNU Lesser General Public License version 3 for more details
  25  * (a copy is included in the LICENSE file that accompanied this code).
  26  *
  27  * You should have received a copy of the GNU Lesser General Public License
  28  * version 3 along with OpenOffice.org.  If not, see
  29  * <http://www.openoffice.org/license.html>
  30  * for a copy of the LGPLv3 License.
  31  *
  32  ************************************************************************-->
  33
  34 <helpdocument version="1.0">
  35 <meta>
  36 <topic id="textscalc0112050100xml" indexer="include" status="PUBLISH">
  37 <title id="tit" xml-lang="en-US">1st, 2nd, 3rd Group</title>
  38 <filename>/text/scalc/01/12050100.xhp</filename>
  39 </topic>
  40 <history>
  41 <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
  42 <lastedited date="2004-07-20T10:50:21">converted from old format - fpe</lastedited>
  43 </history>
  44 </meta>
  45 <body>
  46 <section id="gruppe">
  47 <bookmark xml-lang="en-US" branch="hid/HID_SCPAGE_SUBT_GROUP2" id="bm_id3147335" localize="false"/>
  48 <bookmark xml-lang="en-US" branch="hid/HID_SCPAGE_SUBT_GROUP3" id="bm_id3150085" localize="false"/>
  49 <bookmark xml-lang="en-US" branch="hid/HID_SCPAGE_SUBT_GROUP1" id="bm_id3153252" localize="false"/>
  50 <paragraph role="heading" id="hd_id3149784" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/01/12050100.xhp" name="1st, 2nd, 3rd Group">1st, 2nd, 3rd Group</link></paragraph>
  51 <paragraph role="paragraph" id="par_id3145068" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_SCPAGE_SUBT_GROUP1">Specify the settings for up to three subtotal groups. Each tab has the same layout.</ahelp></paragraph>
  52 </section>
  53 <section id="howtoget">
  54   <embed href="text/scalc/00/00000412.xhp#dntezd"/>
  55 </section>
  56 <paragraph role="paragraph" id="par_id3148797" xml-lang="en-US" l10n="U" oldref="3">To insert subtotal values into a table:</paragraph>
  57 <list type="ordered">
  58 <listitem>
  59 <paragraph role="listitem" id="par_id3154908" xml-lang="en-US" l10n="U" oldref="13">Ensure that the columns of the table have labels.</paragraph>
  60 </listitem>
  61 <listitem>
  62 <paragraph role="listitem" id="par_id3153968" xml-lang="en-US" l10n="U" oldref="4">Select the table or the area in the table that you want to calculate subtotals for, and then choose <emph>Data – Subtotals</emph>.</paragraph>
  63 </listitem>
  64 <listitem>
  65 <paragraph role="listitem" id="par_id3161831" xml-lang="en-US" l10n="U" oldref="5">In the <emph>Group By</emph> box, select the column that you want to add the subtotals to.</paragraph>
  66 </listitem>
  67 <listitem>
  68 <paragraph role="listitem" id="par_id3153188" xml-lang="en-US" l10n="U" oldref="6">In the <emph>Calculate subtotals for</emph> box, select the check boxes for the columns containing the values that you want to subtotal.</paragraph>
  69 </listitem>
  70 <listitem>
  71 <paragraph role="listitem" id="par_id3152460" xml-lang="en-US" l10n="U" oldref="14">In the <emph>Use function</emph> box, select the function that you want to use to calculate the subtotals.</paragraph>
  72 </listitem>
  73 <listitem>
  74 <paragraph role="listitem" id="par_id3154321" xml-lang="en-US" l10n="U" oldref="15">Click <emph>OK</emph>.</paragraph>
  75 </listitem>
  76 </list>
  77 <bookmark xml-lang="en-US" branch="hid/HID_SC_SUBT_GROUP" id="bm_id3163713" localize="false"/>
  78 <paragraph role="heading" id="hd_id3156441" xml-lang="en-US" level="2" l10n="U" oldref="7">Group by</paragraph>
  79 <paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="HID_SC_SUBT_GROUP">Select the column that you want to control the subtotal calculation process. If the contents of the selected column change, the subtotals are automatically recalculated.</ahelp></paragraph>
  80 <bookmark xml-lang="en-US" branch="hid/HID_SCPAGE_SUBT_GROUP" id="bm_id3154492" localize="false"/>
  81 <bookmark xml-lang="en-US" branch="hid/HID_SC_SUBT_COLS" id="bm_id3149379" localize="false"/>
  82 <paragraph role="heading" id="hd_id3154943" xml-lang="en-US" level="2" l10n="U" oldref="9">Calculate subtotals for</paragraph>
  83 <paragraph role="paragraph" id="par_id3147125" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="HID_SC_SUBT_COLS">Select the column(s) containing the values that you want to subtotal.</ahelp></paragraph>
  84 <bookmark xml-lang="en-US" branch="hid/HID_SC_SUBT_FUNC" id="bm_id3149413" localize="false"/>
  85 <paragraph role="heading" id="hd_id3156283" xml-lang="en-US" level="2" l10n="U" oldref="11">Use function</paragraph>
  86 <paragraph role="paragraph" id="par_id3145647" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="HID_SC_SUBT_FUNC">Select the mathematical function that you want to use to calculate the subtotals.</ahelp></paragraph>
  87 </body>
  88 </helpdocument>