dhis2-devs team mailing list archive

Thread
Date

Help - Pivot Tables Export to Excel - Challenge - Each month exported to separate worksheet

To: dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>, dhis2-users@xxxxxxxxxxxxxxxxxxx
From: Beatrice Ngatia <bngatia@xxxxxxxxx>
Date: Sun, 15 Jan 2012 15:27:40 +0300
Reply-to: bngatia@xxxxxxxxx

Hi All,

I am trying to use the DHIS2 Pivot Tables and encountering some challenges.

The challenge lies with the End-Product i.e. the Excel sheet produced once
I follow the * "select Data > Pivot > Download to Excel"* process.  While
I successfully select my pivoting parameters and the table produced on DHIS
seems excellent, My problem is that the resultant Pivot table (once I click
"download to Excel" exports each month to its own separate worksheet and
not onto one combined worksheet where I can then proceed to pivot the data
as desired.

Is this the current set-up within DHIS2 or am I missing a step?

It seems to make sense to me to have all the data exported into one
worksheet, and then pivoted by users as need be.

Please Advise.

Thanks,

Beatrice