I'm attempting to create a pivot table to show the count of created tickets, and the count of resolved tickets and the backlog between the two.

I have the pivot table setup right now so that the Rows are the Ticket Queue names, and there are two columns, Count of Created and Count of Resolved, which gives me the total number of tickets created in that queue on a particular month/week/day/whatever, and the total number of tickets resolved in that same time frame.

The Created and Resolved fields are dates in my datasheet. The pivot table currently looks like this:


Queue Name          Count of Created    Count of Resolved
Ticket Queue 1       100                      95
Ticket Queue 2       55                        35
etc.
etc.
I would like to add a column for "Backlog" which would simply give me the difference in the count. Currently if i add a calculated field and use the formula =Created-Resolved, i get very large or negative numbers, i'm assuming this is because the field is a date field and it's actually subtracting the time between the two columns rather than the count.

I'd like to see my table like this:


Queue Name          Count of Created    Count of Resolved     Backlog
Ticket Queue 1       100                      95                         5
Ticket Queue 2       55                        35                         20
etc.
etc.
I could then add in other data such as month and see the backlog of tickets from month to month. I'd also like this data to be easily updatable, because this information will be processed weekly, monthly and sometimes daily so if i could create the table to display the info i can just update the datasheet and refresh the pivot table to display the new information.


Any help would be greatly appreciated.

Thank you,
Tyler