Git commit 3459911902f70c07dbfffd3febc25d99c1835829 by Yuri Chornoivan. Committed on 11/03/2013 at 20:02. Pushed by yurchor into branch 'master'.
Initial Pivot Table documentation M +75 -0 doc/sheets/advanced.docbook M +10 -0 doc/sheets/commands.docbook M +2 -2 doc/sheets/index.docbook A +- -- doc/sheets/pivot1.png A +- -- doc/sheets/pivot2.png A +- -- doc/sheets/pivot3.png A +- -- doc/sheets/pivot4.png http://commits.kde.org/calligra/3459911902f70c07dbfffd3febc25d99c1835829 diff --git a/doc/sheets/advanced.docbook b/doc/sheets/advanced.docbook index f02b047..0b3f72c 100644 --- a/doc/sheets/advanced.docbook +++ b/doc/sheets/advanced.docbook @@ -258,6 +258,81 @@ calculation. When it finishes and if it has found a solution press the </para> </sect1> + <sect1 id="pivottable"> + <title>Pivot Tables</title> + <para> + &sheets; can be used to construct <ulink url="http://en.wikipedia.org/wiki/Pivot_table";>pivot tables</ulink> using the data of the current table. + </para> + <para>This feature can be invoked by selecting <guimenuitem>Pivot...</guimenuitem> from + the <guimenu>Data</guimenu> menu. Below is an example of pivot table generation. + </para> + <para> + Supposing we have the following data. + </para> + <para> + <mediaobject> + <imageobject> + <imagedata fileref="pivot1.png" format="PNG"/> + </imageobject> + <textobject> + <phrase>Initial table</phrase> + </textobject> + </mediaobject> + </para> + <para> + We want to create a pivot table of our choice and requirement. So we choose + <menuchoice> + <guimenu>Data</guimenu> + <guimenuitem>Pivot...</guimenuitem> + </menuchoice>. + </para> + <para> + The dialog box that will appear allows user to select the source of data. The data can be taken from the current worksheet or from an external source like a database or <abbrev>ODS</abbrev> file. + </para> + <para> + <mediaobject> + <imageobject> + <imagedata fileref="pivot2.png" format="PNG"/> + </imageobject> + <textobject> + <phrase>Choosing the data source</phrase> + </textobject> + </mediaobject> + </para> + <para> + Here is the dialog box which allows the user to customize the pivot table. The column labels in the source data are converted to labels which serve as the working fields. The labels can be dragged and dropped into one of three areas (<guilabel>Rows</guilabel>, <guilabel>Columns</guilabel> or <guilabel>Values</guilabel>) to generate the pivot table. You can reset your choices using <guibutton>Reset DnD</guibutton> button. + </para> + <para> + <mediaobject> + <imageobject> + <imagedata fileref="pivot3.png" format="PNG"/> + </imageobject> + <textobject> + <phrase>Pivot table customization dialog</phrase> + </textobject> + </mediaobject> + </para> + <para> + In our example, <replaceable>Name</replaceable> is dragged to <guilabel>Rows</guilabel>, <replaceable>Category</replaceable> to <guilabel>Columns</guilabel>, <replaceable>Score</replaceable> to <guilabel>Values</guilabel>. User defined functions like sum, average, max, min, count, &etc; can be selected from the <guilabel>Select Option</guilabel> list. + </para> + <para> + The <guibutton>Add Filter</guibutton> button can be used to open filter dialog box to filter the desired data. Using this box you can define multiple filters based on the column label and the relationship between them (<guimenuitem>And</guimenuitem> or <guimenuitem>Or</guimenuitem>). This would allow extreme freedom to customize the output. + </para> + <para> + <mediaobject> + <imageobject> + <imagedata fileref="pivot4.png" format="PNG"/> + </imageobject> + <textobject> + <phrase>Pivot table filtering dialog</phrase> + </textobject> + </mediaobject> + </para> + <para> + <guilabel>Total Rows</guilabel> and <guilabel>Total Columns</guilabel>: checking these allow automatic totalling of corresponding rows and columns in the pivot table. + </para> + </sect1> + <sect1 id="worksheets"> <title>Using more than one Worksheet</title> <para>When you start a new, empty, document with &sheets; it will create a diff --git a/doc/sheets/commands.docbook b/doc/sheets/commands.docbook index dd6709c..537562b 100644 --- a/doc/sheets/commands.docbook +++ b/doc/sheets/commands.docbook @@ -853,6 +853,16 @@ Validity Checking</link> for more details. </para></listitem> </varlistentry> +<varlistentry> +<term><menuchoice> +<guimenu>Data</guimenu> +<guimenuitem>Pivot...</guimenuitem> +</menuchoice></term> +<listitem><para><action>Open the Pivot Table configuration dialog</action>. See +<link linkend="pivottable">Pivot Table</link> for details. +</para></listitem> +</varlistentry> + </variablelist></para> </sect1> diff --git a/doc/sheets/index.docbook b/doc/sheets/index.docbook index 2a413b8..1ca3dc5 100644 --- a/doc/sheets/index.docbook +++ b/doc/sheets/index.docbook @@ -60,8 +60,8 @@ <legalnotice>&FDLNotice;</legalnotice> -<date>2012-12-09</date> -<releaseinfo>2.6</releaseinfo> +<date>2013-03-11</date> +<releaseinfo>2.7</releaseinfo> <abstract> diff --git a/doc/sheets/pivot1.png b/doc/sheets/pivot1.png new file mode 100644 index 0000000..6949fde Binary files /dev/null and b/doc/sheets/pivot1.png differ diff --git a/doc/sheets/pivot2.png b/doc/sheets/pivot2.png new file mode 100644 index 0000000..8945ea3 Binary files /dev/null and b/doc/sheets/pivot2.png differ diff --git a/doc/sheets/pivot3.png b/doc/sheets/pivot3.png new file mode 100644 index 0000000..41f0666 Binary files /dev/null and b/doc/sheets/pivot3.png differ diff --git a/doc/sheets/pivot4.png b/doc/sheets/pivot4.png new file mode 100644 index 0000000..c432c27 Binary files /dev/null and b/doc/sheets/pivot4.png differ
