Need to find the ID that exist in Remaining for current month also exist in upcoming months

[Anonymous]

Hi,

I have a table which consists of the following fields:

Year	Month	Target	Hired	Backlog	Revised Backlog	Total Target	Hired on   backlog
2018	Feb	10	8	2	2	12	0
2018	Mar	20	12	8	8	18	2

Scenario: According to the data, If my Revised Backlog is 2 (Represents 2 Candidate IDs) and these IDs are hired on the  month of Mar, then I need to show my 'Hired on backlog' for the respective month as 2 since 2 IDs which are backlogged in the month of Feb are hired in the month of Mar. So i need to show the value on the 'Hired on Backlog' field as 2. Is there an expression for me to show this? Please help !

[jyothish8807]

Hi Aravind,

In this case where is the Candidate ID ? And how do you define them as backlog ?

Br,

KC

[Anonymous]

This is a sample output. Candidate ID and Target is there in the dataset.

I will count the IDs and group them by month.

Count(ID) is Hired

Backlog = Target - Hired (Eg: 10-8=2, For a specific Month_Year)

[jyothish8807]

Can you share the real data set ?

[Anonymous]

Sorry its not possible. I will share a sample of the real dataset. Hopefully it will be enough to solve this case.

[jyothish8807]

Sure, that will be helpful.

[Anonymous]

Hi this is the sample dataset,

It contains two sheets - Transaction and Master.

1) Transaction_Date is my main date field

2) Target is the Number of Target set for specific transaction date

3) Key is the primary key for both the Master and Transaction Table.

4) Candidate ID is the number of candidates who joined or joining on a specific Joining date.