=== modified file 'src/docbkx/en/dhis2_user_man_using_pivot_table.xml'
--- src/docbkx/en/dhis2_user_man_using_pivot_table.xml 2013-03-18 09:48:04 +0000
+++ src/docbkx/en/dhis2_user_man_using_pivot_table.xml 2013-03-18 17:57:48 +0000
@@ -121,6 +121,10 @@
Several table options are available when working with a pivot table. Open the options
screen by clicking on "Options" in the top menu. The following options are available:
+
+ Show totals: Display total values in the table for each row and column, as well as a
+ grand total for all values in the table.
+
Show sub-totals: Display subtotals in the table for each dimension. In the screenshot
above, notice how subtotals are generated for each of the periods in the period dimension.
@@ -141,15 +145,44 @@
Font size: Controls the size of the table text font. Can be set to "large", "normal"
and "small".
+
+ Digit group separator: Controls which character to separate groups of digits or "thousands". Can
+ be set to "comma", "space" and "none".
+
+ Creating a favorite
+ When you have set up a pivot table it is convenient to save it as a favorite. To do so, click
+ "Favorites" on the top menu, click "Add new", give the favorite a descriptive name and click "Create".
+ You can search for favorites through the search input field at the top. To load an existing favorite,
+ simply click the name of the favorite in the list.
+ To rename a favorite, click the grey "Rename" icon next to the favorite in the list, change the name
+ and click "Update". To overwrite an existing favorite with the current pivot table, click the green
+ "Overwrite" icon. To share a favorite with everyone or a user group, click the blue "Share" icon. To
+ delete a favorite, click the red "Delete" icon.
+
+ The favorite screen.
+
+
+
+
+
+
+
+
Downloading data
You can download the data in the current pivot table by clicking on "Download" in the top
- menu. The data can be downloaded in MS Ecel and CSV format. The data table will have one
- column per dimension. You can easily create a pivot table in Microsoft Excel from the the
- downloaded Excel file by clicking on "pivot table" in the top panel, then clicking on "create
- pivot table", then marking the data range in the spreadsheet before clicking "OK".
+ menu. The data can be downloaded in MS Excel and CSV format. The data table will have one
+ column per dimension and contain names of the dimension items. You can easily create a pivot
+ table in Microsoft Excel from the the downloaded Excel file by clicking on "pivot table" in
+ the top panel, then clicking on "create pivot table", then marking the data range in the
+ spreadsheet before clicking "OK".
+ Data can also be downloaded in JSON and XML format. The data format is specified in the
+ Web API chapter under the "Analytics" section. The data document will use identifiers of the
+ dimension items and will be opened in a new browser window in order to reveal the URL of the
+ request to the Web API in the address bar. This will be useful for developers of apps and
+ other client modules based on the DHIS 2 Web API.
Constraints
=== added file 'src/docbkx/en/resources/images/pivot_table/pivot_favorites.png'
Binary files src/docbkx/en/resources/images/pivot_table/pivot_favorites.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/pivot_table/pivot_favorites.png 2013-03-18 17:57:48 +0000 differ