Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you so much, it worked.