I am using set analysis in the Pivot chart. and also ignoring the selection of one column. But I am not getting correct values.
Attaching the application.
In 'Alliance Sent Check' column, I am trying to get Alliance Total Call count by ignoring the agent. Also I am trying to add ' Script_Inbound=1' in set analysis. But for those agents who has script_Inbound=0, I am getting '0' count in 'Alliance Sent Check' column. I tried using below formula (suggested by stalwar1) but in that case when I am selecting any agent, it doesnt show me correct values.