jonespandrew
New member
- Joined
- Jan 27, 2016
- Messages
- 122
- Reaction score
- 0
- Points
- 0
Hi From a Pivot table I have created I am trying to add in a field that show Percentage of calls attended and percentage of calls resolved, i know the formulae which is lowest number/highest number but how do i do this as a calculated field.
I have toyed with the idea of having 3 colloums 1 to show attended 1 to show attended late then using a calulated field add those two colums together to show total calls attended then create a nother calulated feild showing total calls then work out the percentage from that.
Hope it make sense
I have toyed with the idea of having 3 colloums 1 to show attended 1 to show attended late then using a calulated field add those two colums together to show total calls attended then create a nother calulated feild showing total calls then work out the percentage from that.
Hope it make sense