Hi Lars, Thank you for this very clear instruction. It is straightforward and very useful!
Regards, Tantely. Le 7 avr. 2017 6:25 PM, "Lars Helge Øverland" <l...@dhis2.org> a écrit : > > Hi Tantely, > > to achieve this I think you should use the "org unit group" selection > mode. Under the organisation unit dimension section, click the gear icon > and select "Select groups", then select the org unit group which contains > the org units you would like to display. > > In the org unit tree you can leave the selected org unit at the national > level if you would like to include facilities from the entire country. > > > [image: Inline image 3] > > > This will render the actual org units from that group in your pivot table. > > regards, > > Lars > > > > > > On Thu, Apr 6, 2017 at 5:38 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Dear community, >> >> I am trying to create a filter to be used with the pivot table results, >> so that only the filtered OrgUnits will appear. For that I have created >> OrgUnit groups and have used them in the pivot table. The layout is >> illustrated in the attached file, by using the OrgUnits in the row >> dimensions. As a result, the pivot table is only using the OrgUnit groups >> as a categorization of the results but not filtering them as all OrgUnits >> are still displayed. I think that an interest using a filter is to avoid >> dumping a huge amount of data, which is sometimes freezing DHIS2 when >> displaying the results at the lowest level of OrgUnits. >> >> Which way should I follow in order to filter the OrgUnits according to >> some criteria (like using a spreadsheet filter)? Would it be possible doing >> that in the pivot table or it would be worth creating an equivalent SQL >> uery? One constraint with using SQL View is that we can only call >> DataElements but not Indicators. >> >> I am using DHIS2 2.24. >> >> Thank you for your support and suggestions! >> >> Regards, >> >> Tantely. >> >> *This message and its attachments are confidential and solely for the >> intended recipients. If received in error, please delete them and notify >> the sender via reply e-mail immediately.* >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > -- *This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
