helpcontent2/source/text/scalc/guide/datapilot_grouping.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3
   4
   5 <!--
   6  ***********************************************************************
   7  *
   8  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   9  *
  10  * Copyright 2008 by Sun Microsystems, Inc.
  11  *
  12  * OpenOffice.org - a multi-platform office productivity suite
  13  *
  14  * $RCSfile: datapilot_grouping.xhp,v $
  15  * $Revision: 1.8 $
  16  *
  17  * This file is part of OpenOffice.org.
  18  *
  19  * OpenOffice.org is free software: you can redistribute it and/or modify
  20  * it under the terms of the GNU Lesser General Public License version 3
  21  * only, as published by the Free Software Foundation.
  22  *
  23  * OpenOffice.org is distributed in the hope that it will be useful,
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  26  * GNU Lesser General Public License version 3 for more details
  27  * (a copy is included in the LICENSE file that accompanied this code).
  28  *
  29  * You should have received a copy of the GNU Lesser General Public License
  30  * version 3 along with OpenOffice.org.  If not, see
  31  * <http://www.openoffice.org/license.html>
  32  * for a copy of the LGPLv3 License.
  33  *
  34  ************************************************************************
  35  -->
  36
  37
  38                 <helpdocument version="1.0">
  39 <meta>
  40 <topic id="textscalcguidedatapilot_groupingxml" indexer="include" status="PUBLISH">
  41 <title id="tit" xml-lang="en-US">Grouping DataPilot Tables</title>
  42 <filename>/text/scalc/guide/datapilot_grouping.xhp</filename>
  43 </topic>
  44 </meta>
  45 <body>
  46 <bookmark xml-lang="en-US" branch="index" id="bm_id4195684"><bookmark_value>grouping; DataPilot tables</bookmark_value>
  47 <bookmark_value>DataPilot function;grouping table entries</bookmark_value>
  48 <bookmark_value>ungrouping entries in DataPilot tables</bookmark_value>
  49 </bookmark>
  50 <paragraph role="heading" id="par_idN10643" xml-lang="en-US" level="1" l10n="NEW"><variable id="datapilot_grouping"><link href="text/scalc/guide/datapilot_grouping.xhp">Grouping DataPilot Tables</link>
  51 </variable></paragraph><comment>see http://specs.openoffice.org/calc/compatibility/grouping.sxw</comment><paragraph role="paragraph" id="par_idN10661" xml-lang="en-US" l10n="NEW">The resulting DataPilot table can contain many different entries. By grouping the entries, you can improve the visible result.</paragraph>
  52 <list type="ordered">
  53 <listitem>
  54 <paragraph role="paragraph" id="par_idN10667" xml-lang="en-US" l10n="NEW">Select a cell or range of cells in the DataPilot table.</paragraph>
  55 </listitem>
  56 <listitem>
  57 <paragraph role="paragraph" id="par_idN1066B" xml-lang="en-US" l10n="CHG">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph>
  58 </listitem>
  59 </list>
  60 <paragraph role="paragraph" id="par_idN1066E" xml-lang="en-US" l10n="NEW">Depending on the format of the selected cells, either a new group field is added to the DataPilot table, or you see one of the two <link href="text/scalc/01/12090400.xhp">Grouping</link> dialogs, either for numeric values, or for date values.</paragraph>
  61 <paragraph role="paragraph" id="par_id3328653" xml-lang="en-US" l10n="NEW">The DataPilot table must be organized in a way that grouping can be applied.</paragraph>
  62 <list type="unordered">
  63 <listitem>
  64 <paragraph role="paragraph" id="par_idN10682" xml-lang="en-US" l10n="CHG">To remove a grouping, click inside the group, then choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph>
  65 </listitem>
  66 </list>
  67 <section id="relatedtopics">
  68 <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
  69 <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
  70 <embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/>
  71 <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
  72 <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
  73 <embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
  74 </section>
  75 </body>
  76 </helpdocument>