dhis2-users team mailing list archive

[Beatrice Ngatia <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