creating a simple report
creating a simple report
In a Pivot Table, how can I filter an individual field but not filter all of the incoming data?
What I want is a simple report listing the following, using the data imported from Zoho Desk -
Agent Tickets Assigned Tickets Resolved
John Doe 1,200 1,100
Tickets Assigned will be the total number of tickets assigned in the given period [Filter all records by date range]
Tickets Resolved will be the total number of 'Resolved' tickets in the time period - I need to be able to filter this individual field to ONLY total the tickets with 'Resolved' in the status field.
If I try to define this in the Filter options,I only get the tickets that meet both criteria - the date range and the value of 'Resolved'