Expression problem

[#1]

Hi all,

I have got an Excel Pivot table  like the one below,

!

I have tried this in QV ,please the attached files

Dimension:=ValueList('C2D_Used','No_Of_Agents')  and Day

Expresion:

=pick(Match(ValueList('C2D_Used','No_Of_Agents'),

                  'C2D_Used','No_Of_Agents'),                

                 if(sum(if(CallTime > 0 , 1, 0)) > 0,'Y','N'),

                 Count(DISTINCT Consultant))

This does not give the needed result, it does not give me the 'N'. please assist.

PFA

[#2]

Thank you so much, it worked.