Age Group

I am new to DHIS2 and I am finding it challenging to design a pivot table with multiple categories, eg; a pivot table that has age-groups per gender in an orgunit plus other indicators? Data was collected using a Tracker Program. A step by step approach will be highly appreciated.

1 Like

Hi @spalavi

You can use program indicators and create for each age group so they can be used in pivot tables and visualizer.

Or else you can use legends and apply them on the attribute age then use it in events.


1 Like


Hi Prosper,

Thanks for reply and please could you help me creating this table attached in DHIS2.

Much appreciate your help.


1 Like

Dear @spalavi

With legends you can achieve this

and this

1 Like


Happy to hear from you and appreciate all your help. Please take note I am new to this and I am trying to figure out how to retrieved aggregate values data on event report. Refer to the attachment below there is no data

Also let me know how to setup range set.


1 Like

Hi @spalavi

Sorry for the shortcuts,

To create legends; what is referred as range in events reports; Go to maintenance>> All>> Legends
Add a legend according to your ranges

After creating the legend, then assign the legend to your age attribute (tracker) or data element(events)

Note you can assign more than one legend allowing you to switch in between different age ranges

Regards and hope this helps

1 Like