dhis2-users team mailing list archive

[Morina Matasi <morena.motsieng@xxxxxxxxx>]

I have a unique scenario here. I have a report which is supposed to list
monthly data BUT one of the columns will be a percentage of the quarterly
figures.

See Below sample data


                                        ANC Visits
Percentage of Quarter
Facility 1     January          100
100/(100+150+123)
Facility 1     February         150
150/(100+150+123)
Facility 1     March              123
123/(100+150+123)
Facility 2     January          112
112/(112+156+145)
Facility 2     February         156
156/(112+156+145)
Facility 2     March              145
145/(112+156+145)
....
....
....
Facility N


>From the above data, column Percentage of Quarter should use data from the
other three columns (January+February+March) and I guest I need a sub-query
for this. How do I go about this.


Regards,

Moses Marimo