Index: /branches/dev/html/admin/total/index.php
===================================================================
--- /branches/dev/html/admin/total/index.php	(revision 13352)
+++ /branches/dev/html/admin/total/index.php	(revision 13413)
@@ -659,5 +659,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";