# How can I create custom report - Number of cases agency by reported year

**URL:** <https://support.primero.org/forum/t/how-can-i-create-custom-report-number-of-cases-agency-by-reported-year/648>\
**Category:** CPIMS\
**Tags:** v2-0\
**Created:** [December 26, 2022, 1:25pm UTC](https://support.primero.org/forum/t/how-can-i-create-custom-report-number-of-cases-agency-by-reported-year/648 "2022-12-26T13:25:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ktun](https://support.primero.org/forum/letter_avatar_proxy/v4/letter/k/ecccb3/32.png) [@ktun](https://support.primero.org/forum/u/ktun)\
**Post date:** [December 26, 2022, 1:25pm UTC](https://support.primero.org/forum/t/how-can-i-create-custom-report-number-of-cases-agency-by-reported-year/648/1 "2022-12-26T13:25:23Z")

</div>

I am trying to create a report to have a year-by-year reported/identified number of cases by the agency in the customized report function. I could not find any date field in the group by row and column function. I need the following data table. Kindly let me know how to create this report.

 ![Capture](https://support.primero.org/uploads/primero/original/1X/393c79687b052033faa30f50b56238bd1aa433c4.jpeg)

Thanks,

---

<div class="post-metadata">

**Author:** ![childprotectioninnov](https://support.primero.org/forum/letter_avatar_proxy/v4/letter/c/e8c25b/32.png) [@childprotectioninnov](https://support.primero.org/forum/u/childprotectioninnov)\
**Post date:** [January 5, 2023, 7:41pm UTC](https://support.primero.org/forum/t/how-can-i-create-custom-report-number-of-cases-agency-by-reported-year/648/2 "2023-01-05T19:41:43Z")

</div>

For the agency by year, that isn’t currently possible to do a report by year but we are moving the database to SQL this quarter and once this is done you will be able to do a report that looks like the one you have shared. At this moment, the only way to create a report like this is to apply filters for each year and export the data to CSV.