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 <[email protected]> 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 : [email protected] > 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.
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
