Index: /branches/rel/html/admin/total/index.php
===================================================================
--- /branches/rel/html/admin/total/index.php	(revision 13354)
+++ /branches/rel/html/admin/total/index.php	(revision 13426)
@@ -653,5 +653,5 @@
 	
 	$sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average ";
-	$sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 ";
+    $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 and T2.status <> " . ORDER_CANCEL;
 	$sql.= "GROUP BY job ORDER BY total DESC";