Desktop productivity for business analysts and programmers

Extracting the Count based on several Conditions

Reply
Occasional Contributor
Posts: 7

Extracting the Count based on several Conditions

I have the Employee List and front of them have the city where they belong, I want to give the Customers to these employees based on category which i have created.

 

Table 1. So i have the Employee , city , and the count of customers needed from the category ( Two category 1 & 2)

Table 2. I have Customers and City and Category in next table.

 

I want to extract the Customers and want to give to the employee

I have mention the category wise count which is needed

Please help

 

Output needed :-

CUSTOMER NAME , CITY , CATEGORY , EMPLOYEE NAME

 

Attacing the Excel file for the same

Super User
Posts: 19,167

Re: Extracting the Count based on several Conditions

Is this different than the question you've posted in Base Programming? 

 

Please post sample data in your question, not as an attachment or image. 

Ask a Question
Discussion stats
  • 1 reply
  • 204 views
  • 0 likes
  • 2 in conversation