dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Beatrice,

Nice to hear from you again. :)

The better solution would be to use the MyDatamart tool described here

http://dhis2.org/doc/snapshot/en/user/html/apb.html


This tool will provide you with a normal pivot table, which can be
manipulated as per normal by users.


Best regards,
Jason


On Sun, Jan 15, 2012 at 2:27 PM, Beatrice Ngatia <bngatia@xxxxxxxxx> wrote:
> 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
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>