Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
i have a sales header and sales detail tables. also a target sales table for salesman in excel. I am supposed to compare actual sales done by salesmen with respect to target from excel. the key to be used is a composite key with the combination of month, brand and salesman number. after linking the tables, i am getting details of salesman which are common in both target and actual. but not the details of target alone. ie; if a salesman hasn't done any sales as per planned for any brand, that value is not shown.
Please help!!!!!
could you elaborate. i will attach the sample data for your reference.
Take a look at 'NOT EXISTS' for your load.