Hi Everyone,
I have a spreadsheet from an I.T. Help Desk, which shows the tickets in the system and pertinent dates related to the ticket (as attached).
So far I have successfully been able to format the the date columns and sort them by year / month, as shown below -
2iwam3n.jpg
I now want to create a summary of the number of tickets closed each year / month. Whilst I am aware of the Subtotal function, which I have been experimenting with I have not successfully been able to produce my desired data.
E.g.:
# of Ticket Closed | Year / Month
2 | 2013 / Feb
x | 2013 / March
etc...
Any help with how to produce a report with output similar to above will be greatly appreciated.
Kind Regards,
Davo
Bookmarks