dhis2-users team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

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.*

Attachment: Pivot_Table_Layout.pdf
Description: Adobe PDF document