I have a main table with an associated lookup via a left join. QV file and dataset attached ( Please note this is just a subset of data, my actual dataset is a lot larger however the fields are exactly what you see).
I am joining on SALES_ID with the resultant table displayed. Quite simply what I wish to do is for all the SALES_ID values that are in the main table but not in the lookup ( these all begin 99 ), then put the SALES_TYPE_NEW into a separate bucket called 'TAXABLE'. Current output and expected output displayed below.
