dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

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> 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>
> 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 | Mobile: +265 (0)
>> 88 4 245 431
>>
>> kmalewezi@xxxxxxxxxxx <mailto:kmalewezi@xxxxxxxxxxx > |  www.jhpiego.org<
>> http://www.jhpiego.org/>
>>
>> Skype: kabango.malewezi | Twitter: kabangoM
>>
>> _______________________________________________
>> 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
>>
>