calculo de diferentes gupos en una misma consulta

[juan_aalberto]

Código MySQL:

SELECT 
CAST(
IF( depositos IS NULL 
AND retiros IS NULL 
AND matrize_id IS NULL,
'Total', 
IF(
depositos IS NULL 
AND retiros IS NULL, 'Subtotal', matrize_id)) AS CHAR)`matrize_id`,
CAST(IFNULL(`depositos`, '') AS CHAR) depositos,
CAST(IFNULL(`retiros`, '') AS CHAR) retiros, `balance`
FROM 
(SELECT `matrize_id`, `depositos`, `retiros`, 
SUM(`depositos`- `retiros`) balance
FROM `test`.`op_matrizes`
GROUP BY `matrize_id`, `depositos`,`retiros` WITH ROLLUP) T1
WHERE (depositos IS NULL AND retiros IS NULL) 
OR (depositos IS NOT NULL AND retiros IS NOT NULL)
 

Ahora me marca este error:
#1146 - Table 'test.op_matrizes' doesn't exist