Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Attaching the files and application.
Thanks!
May be try this
=Sum(Aggr(Sum(TOTAL <Alliance> {<Agent, Director>}
Aggr(Sum({<Script_Inbound={1}, Alliance = p(Alliance),
Agent, Director>} Sent),
Director, Agent, Alliance)),
Director, Agent, Alliance))
May be try this
=Sum(Aggr(Sum(TOTAL <Alliance> {<Agent, Director>}
Aggr(Sum({<Script_Inbound={1}, Alliance = p(Alliance),
Agent, Director>} Sent),
Director, Agent, Alliance)),
Director, Agent, Alliance))
Thank you Sunny. Its working as expected.