dhis2-users team mailing list archive

[Moses Marimo <marimo@xxxxxxxxx>]

Hey apologies. I just send an email from a colleague's computer. Anyway, a
bit of more information. I need all columns to be in the detail section. I
could used sub totals to get the total for the three months but them, the
design of the report becomes distorted. Is this practical????

On Thu, Nov 27, 2014 at 9:28 AM, Morina Matasi <morena.motsieng@xxxxxxxxx>
wrote:

> 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
>
> _______________________________________________
> 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
>
>


-- 
ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
7 Chelmsford Belgravia, Harare
Tel: +263-8644-102349
Cell: +263-772-268353
Website: *www.ict.co.zw <http://www.ict.co.zw>*


Innovative solutions in Web Design and E-Commerce, Software Engineering,
Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT
Solutions and Consultancy.