Hi Nicolene,
Thank you for contacting Clarizen Support. This should be possible to achieve with our Excel add in app, that is our Advanced Reporting tool: http://www.clarizen.com/appsmarketplace/item/Clarizen-Excel-Add-in . To request a free trial, please reach out to your Account Executive.
Currently, we are also working on improving our existing reporting module which should be released beginning of 2015.
For further clarification, we suggest you register for one of our Advanced Q&A webinars (see the link-> http://www.clarizen.com/resources/online-demo.html#second ).These are great resources for free consulting with our Customer Success Managers and visual answers to your questions.
All the best,
Diana