← Back to team overview

dhis2-kenya team mailing list archive

Re: Creation pivot tables at a local office

 

Hi Cheburet,

The mydatamart ("data downloader") for the pivot tables requires MS Excel
2007 or newer, so Excel 2003 is not supported.

Please tell us exactly which datasets/data elements that are not in the
pivot tables and I can have a look.

I sent an updated pivot table file to Manya on Wednesday, I hope you have
got that one. I will forward now.

Ola
-------

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>


On 9 October 2011 12:54, samuel cheburet <samuelcheburet@xxxxxxxxx> wrote:

> Dear all,
>
>
> On the above subject. I have tested the pivot table and have some deficit.
>
> one the pivot table is fixed to .xlsx and not xls. This mean all the Ms
> office for window require upgrade to office 2007 and above.Also the pivot
> table does not capture all the dataset as it apper in the database even if
> the data is there and grouped.
>
> i proposed one to create pivot based on the existing format of Ms office
> e.g dhis2ke_pivots.xlsx or dhis2ke_pivots.xls. Also it should be auto
> generate pivot.
>
>
> Cheers
>
> --
> Samuel Cheburet
> Ministry Of Health
> P.O. Box 20781
> Nairobi, Kenya
> Mobile- 0721624338
>
> *Don't Compromise The Quality! Don't Risk It! apply Available Standards to
> Achieve Your/organizational Goal.*
>

References