[Dhis2-users] Help - Pivot Tables Export to Excel - Challenge - Each month exported to separate worksheet

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

Re: [Dhis2-users] Help - Pivot Tables Export to Excel - Challenge - Each month exported to separate worksheet

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

Re: [Dhis2-users] Help - Pivot Tables Export to Excel - Challenge - Each month exported to separate worksheet

Hi Beatrice, I think you might have selected too much data for download. If you are downloading data for the Kenya orgunit you should not select facility as the analysis level, it will be way too much to download. Try to use district or county level instead. Or if you need facility level, first