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 <bnga...@gmail.com> 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp