Generate Monthly Report

Hi,

I have to create a report based on user requirements as per below:

Questions:

1) How to create year parameter? When user filter by year - data will be display in monthly.

2) How to count total product for each month? The report will also display null values data and column header for month is static. Do I have to create a formula field to count total product for each month?

Fields that will be use in this report are location, product name, date (dateTime value). Need someone that can assist me to generate this report.

Thanks.