Extracting the Count based on several Conditions

Hii, Please help , I have BASE DATA in which I have category-wise Customers I want to give the Customers to each employee based on category, (which I have mentioned the Count) - RESULT REQUIRED TABLE There should not be duplicate of customers Example :- Emp 1 want 27 customer from category A so , pull or extract the Customers from BASE DATA table category A ,So after the extraction the count remaining should be ( 8000-27 = 7973) , for EMP 2 , We want 21 from A category so pull out customers form BASE DATA category A (7973).

Attaching the file for the same

Hi Ankur,

So if you see the BASE DATA table , this table contains the Customer and the category & if you see the result required table , I have EMPLOYEE NAME & COUNT OF CUSTOMER REQUIRED FROM EACH CATEGORY

Ankur , I have attached the file for the data

So, Form base data, I wanted to extract the Customers.