dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

It is possible actually using custom SQL. We have developed such views for
MyDatamart in Zambia. The general approach we used is to use UNION
statements to bring data elements and indicators together into a single
view. If you need more specifics, let me know.

--
Sent from my mobile
On Jul 20, 2012 7:04 AM, "Ola Hodne Titlestad" <olati@xxxxxxxxxx> 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
>>
>
> _______________________________________________
> 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
>
>