The pivot table below is counting the number of tickets handled by agents on each row (by counting the reference numbers that appear in the data set against each name on any given day).
Where the corresponding date is blank in the pivot table the assumption is the agent didn't work.
I'd like to create a column in the pivot table that counts the number of days that the agent did work.
(NB: the grand total is counting the total number of tickets handled by each agent and changing it to summarize by anything other than "count" causes the entire table to start math operations on the reference numbers instead of the number of times they occur).
[/URL]****
**** async src="//embedr.flickr.com/assets/client-code.js" charset="utf-8">*********>[/IMG]
Where the corresponding date is blank in the pivot table the assumption is the agent didn't work.
I'd like to create a column in the pivot table that counts the number of days that the agent did work.
(NB: the grand total is counting the total number of tickets handled by each agent and changing it to summarize by anything other than "count" causes the entire table to start math operations on the reference numbers instead of the number of times they occur).
**** async src="//embedr.flickr.com/assets/client-code.js" charset="utf-8">*********>[/IMG]