--- a/displayProcurementMethod.php
+++ b/displayProcurementMethod.php
@@ -10,8 +10,9 @@
 */
 
 include_header("Procurement Methods");
-$query = "SELECT value, procurementMethod
+$query = "SELECT SUM(value) as value, procurementMethod
 FROM `contractnotice`
+WHERE childCN = 0
 GROUP BY procurementMethod ";
 
 $result = mysql_query($query);