dhis2-users team mailing list archive

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

This is essentially what I have done with the view. The final trick is to
adjust the Excel formula to aggregate indicators in one way and calculated
data elements (also indicators) and regular data elements in another way.
With this dynamic definition of the Excel formula,one can aggregate both
indicators and data elements in the same pivot normally. More details
(code) tomorrow.

--
Sent from my mobile
On Jul 20, 2012 1:43 PM, "Bob Jolliffe" <bobjolliffe@xxxxxxxxx> wrote:

> I guess another workaround might be to create simple naive indicators
> (ie denominator=1) but this could easily lead to indicator
> proliferation.
>
> On 20 July 2012 18:39, Ola Hodne Titlestad <olati@xxxxxxxxxx> wrote:
> > 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
> >
> >
> > _______________________________________________
> > 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
>