i created a quri that broke line in few saparate and when its come to resolt it still showing the one that i origanaly broke i dont need that how can i make it not show in final resolt
select distinct
A1.Month,
A1.Scenario,
A1.Account,
A1.Organisation,
A1.Tracking_Category_2,
A1.Tracking_Category_1,
case
when A1.Month = B2.Date
and a1.Tracking_Category_1 = AllocateFromTc
then AllocateToTc
else 'x'
end as Tracking_Category_d,
A1.TEXT_VAL,
case
when A1.Tracking_Category_1 = AllocateFromTc
and A1.Month = B2.Date
then A1.Amount*[Percent]/100
else A1.Amount
end as Amountd
,A1.Amount
from OLAP.VW_CUBE_Finance_NAMES A1 , OLAP.Test B2
exsample of resolt the line that broke is x
Month Tracking_Category_d Amountd Amount
2020-11-01 Houses: NHome -168953.465 -675813.86
2020-11-01 Houses: N-KL -337906.93 -675813.86
2020-11-01 Houses: NGR -168953.465 -675813.86
2020-11-01 x -675813.86 -675813.86