Need help on filter

[Anonymous]

Hi Team,

I have two table ,candidate details table and Date table,Requirment to get the details of the candidate L1 interviews status and L2 interview status based on the Reporting weeks 

This Reporting week i had created in Date table 

I had created an measure to get count of L1 Status Details based on the Reporting week as in the below screen shot it result like this 

I have a candidate table which has candidate details as shown in the below screen shot 

the issue is result of the L1 details is not matching with the candidate table details 

I need the candidate details to be as same as the L1 details table as shown in the below screen shot

L1 reject should be 1 and L1 Select should be 1 and No Show should be 2 as in the L1 details 

Could somebody help me to resolve this issue 

@amitchandak, @Greg_Deckler,

@guillouzada ,

@BiNavPete ,

@MP-iCONN ,

@mrcss23 ,

@Jeanxyz ,

 @v-xiaotang 

[guillouzada]

So given the details table above are you expecting the result of the measure (L1 details) as follows?

STATUS	29-JAN-12
L1 Reject	5
Screen Reject	4

[Anonymous]

Hi Guillouzada,

candidate table details should be matched with L1 details 

For Example if the L1 details has L1 Reject 2 and L1 select 1

the same count result should be shown in candidate table 

This Candidate detail table are directly imported from the excel data source 

[guillouzada]

Hi @Anonymous 

For better understanding...

Is the table below the one that you're importing to the report? 

If its not could you provide a sample?

[Anonymous]

Hi Guillouzada,

Thanks for your support 

yes the table I'm import from the excel data source