=== modified file 'src/docbkx/en/dhis2_user_man_reporting.xml' --- src/docbkx/en/dhis2_user_man_reporting.xml 2010-11-02 13:36:48 +0000 +++ src/docbkx/en/dhis2_user_man_reporting.xml 2010-11-02 15:08:33 +0000 @@ -559,9 +559,8 @@
Design the pivot table -
-
- Office 2003 +
+ Office 2003 1) Open a new blank spreadsheet 2) Go to Data --> PivotTable and PivotChartReport. @@ -584,11 +583,12 @@ 10) Additional step for indicator tables: - Your indicator values should be calculated by Excel using the formula "Factor*Numerator/Denominator" to make sure Excel aggregates the values (such as percentages) properly. This can be done by inserting a calculated field into the Data field area. In the layout window in the wizard just put any field in data field, e.g. denominatorvalue (the wizard does not accept an empty data field). Then close and when you can see the table in normal view select the denominatorvalue field and in the top menu go to Insert->Calculated field. In the new window you can give your field the name e.g. IndicatorValue and specify the formula based on the available fields in the list to form the formula 'numxfactor/denominatorvalue'. numxfactor is a pre-calculated value of the factor x numeratorvalue. + Your indicator values should be calculated by Excel using the formula "Factor*Numerator/Denominator" sto make sure Excel aggregates the values (such as percentages) properly. This can be done by inserting a calculated field into the Data field area. In the layout window in the wizard just put any field in data field, e.g. denominatorvalue (the wizard does not accept an empty data field). Then close and when you can see the table in normal view select the denominatorvalue field and in the top menu go to Insert->Calculated field. In the new window you can give your field the name e.g. IndicatorValue and specify the formula based on the available fields in the list to form the formula 'numxfactor/denominatorvalue'. numxfactor is a pre-calculated value of the factor x numeratorvalue. -
-
- Office 2007 + +
+
+ Office 2007 1) open a new worksheet 2) Go to Data menu, then From Other Sources, From Microsoft Query @@ -613,7 +613,12 @@ 12) Save your file and the next time you have new data in your data mart you can refresh the pivot table to see all the data in your data mart (filtered by your pivot view), both old and new data. - 13) If you for some reason need to empty your pivot table, e.g. to send to another computer over email, and you cannot send with data (big size), you can first empty/clean the data mart from the DHIS Data Administration window, and then refresh your pivot table. + 13) If you for some reason need to empty your pivot table, e.g. to send to another computer over email, and you cannot send with data (big size), you can first empty/clean the data mart from the DHIS Data Administration window, and then refresh your pivot table. + + 10) Additional step for indicator tables: See instructions for 2003 above. + + +