Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
So my question is that as seen in the below images the value in the cost column is reflecting while selecting some zone . The formula which i have used for Cost Column is :
(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])
What should i do to not reflect the values? Is there any alternative way?
Try this:
(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])
So you mean that value should not change based on selection in Zone Field? Try this may be
(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])
Hey,
It is kind of working, but it is affecting the totals column as u can see in the below image and Zone is not getting selected.
Not sure I follow the issue. What is wrong with Total? Extra rows?
Hey ,
Can u find the difference in both the images?? When i select a specific zone it shows all the elemnts in that zone column, the selection which m doing is not getting specificaly selected.
Try this:
(92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}, Zone>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])
Thankyou so much it worked