dhis2-users team mailing list archive

[Kabango Malewezi <kmalewezi@xxxxxxxxxxx>]

I get it I'll just use reports.
Sent from my BlackBerry® smartphone
________________________________
From: Ola Hodne Titlestad <olati@xxxxxxxxxx>
Sender: <olatitle@xxxxxxxxx>
Date: Fri, 20 Jul 2012 19:39:08 +0200
To: Kabango Malewezi<kmalewezi@xxxxxxxxxxx>
Cc: <dhis2-users@xxxxxxxxxxxxxxxxxxx>; Jason Pickering<jason.p.pickering@xxxxxxxxx>
Subject: Re: [Dhis2-users] Datamart


Jason,
How do you handle the values in this view? Indicator values should be set up as a calculated field to let excel aggregate numerators and denominators separately for percentage values. If not the values for higher levels will be wrong.

Or are you using only one orgunit level in this view?

I guess it is possible to use two separate value fields for data elements and indicators in the same pivot table?
Sounds confusing, but for a very specific/static table maybe.... but then I would recommend standard reports.

Ola
-------

On Jul 20, 2012 7:24 PM, "Kabango Malewezi" <kmalewezi@xxxxxxxxxxx<mailto:kmalewezi@xxxxxxxxxxx>> wrote:

Hi Kabango,

That is not possible.

You can do it with report tables and standard reports.

Ola
-------

On Jul 20, 2012 10:49 AM, "Kabango Malewezi" <kmalewezi@xxxxxxxxxxx<mailto:kmalewezi@xxxxxxxxxxx>> wrote:
Gentle People,



I'd like to have Elements and indicators in one excel pivot table. How do I do that? The available views I have have either Pivot_Indicator or Pivot_Routinedata.



Kabango Malewezi

SSDI Services

2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410<tel:%2B265%20%2801%29%20776%20410> | Mobile: +265 (0) 88 4 245 431<tel:%2B265%20%280%29%2088%204%20245%20431>

kmalewezi@xxxxxxxxxxx<mailto:kmalewezi@xxxxxxxxxxx> <mailto:kmalewezi@xxxxxxxxxxx<mailto:kmalewezi@xxxxxxxxxxx> > |  www.jhpiego.org<http://www.jhpiego.org><http://www.jhpiego.org/>

Skype: kabango.malewezi | Twitter: kabangoM

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp