Help with Adding Target Value to Sales Dashboard Query

I haven’t been capable to fig retired however to instrumentality this functionality. Below is the SQL query I person truthful far. Can anyone assistance maine fig retired however to modify it to see the people worth successful a caller column?

SELECT
"CardCode" arsenic "Customer Code",
"CardCode",
"CardName" AS "Customer Name",
"DocDate" arsenic "Posting Date",
U."USER_CODE" AS "User Code",
"Total" arsenic "Total Sales Amount",
"Total" arsenic "Total Sales Amount"
FROM
(
(SELECT
T0."CardCode",
T0."CardName",
T0."DocDate",
T0."DocTotal" + IFNULL((SELECT SUM(t4."Gross") FROM inv9 t4 WHERE T0."DocEntry" = t4."DocEntry"), 0) AS "Total",
CASE
WHEN E1."userId" IS NULL THEN T0."UserSign"
ELSE E1."userId"
END AS "UserId"
FROM
oinv T0
LEFT JOIN
(
SELECT
"empID",
"userId",
"salesPrson"
FROM
OHEM
WHERE
"userId" IS NOT NULL AND "salesPrson" IS NOT NULL
) E1 ON T0."SlpCode" = E1."salesPrson"
WHERE
T0."CANCELED" = 'N'
)
UNION ALL
(SELECT
T1."CardCode",
T1."CardName",
T1."DocDate",
(-1) * (T1."DocTotal" + IFNULL((SELECT SUM(t5."Gross") FROM rin9 t5 WHERE T1."DocEntry" = t5."DocEntry"), 0)) AS "Total",
CASE
WHEN E1."userId" IS NULL THEN T1."UserSign"
ELSE E1."userId"
END AS "UserId"
FROM
orin T1
LEFT JOIN
(
SELECT
"empID",
"userId",
"salesPrson"
FROM
OHEM
WHERE
"userId" IS NOT NULL AND "salesPrson" IS NOT NULL
) E1 ON T1."SlpCode" = E1."salesPrson"
WHERE
T1."CANCELED" = 'N'
)
UNION ALL
(SELECT
T2."CardCode",
T2."CardName",
T2."DocDate",
"DocTotal" AS "Total",
CASE
WHEN E1."userId" IS NULL THEN T2."UserSign"
ELSE E1."userId"
END AS "UserId"
FROM
OCSI T2
LEFT JOIN
(
SELECT
"empID",
"userId",
"salesPrson"
FROM
OHEM
WHERE
"userId" IS NOT NULL AND "salesPrson" IS NOT NULL
) E1 ON T2."SlpCode" = E1."salesPrson"
WHERE
T2."CANCELED" = 'N'
)
UNION ALL
(SELECT
T3."CardCode",
T3."CardName",
T3."DocDate",
(-1) * "DocTotal" AS "Total",
CASE
WHEN E1."userId" IS NULL THEN T3."UserSign"
ELSE E1."userId"
END AS "UserId"
FROM
OCSV T3
LEFT JOIN
(
SELECT
"empID",
"userId",
"salesPrson"
FROM
OHEM
WHERE
"userId" IS NOT NULL AND "salesPrson" IS NOT NULL
) E1 ON T3."SlpCode" = E1."salesPrson"
WHERE
T3."CANCELED" = 'N'
)
) T
INNER JOIN
OUSR U ON T."UserId" = U."USERID"