QM status tracking Report

Hi Experts,

I have a requirement for a report in BW showing different Status counts per Weeks as shown in below

Status Week1 WeeK2 Week3---n(Date Range as Per User)

S1 10 10 15

S2 9 11 15

For eg In Week1 10 Notification were having Status (S1)

Currently we have Developed a ABAP Query to fetch All the Status Changes for a Notification to the Data Source(QMEL+JCDS).

I'm ABAP consultant so please advise is it possible to filter the data according to the dates and sum it based on Status in BW?

or is there any other way?

Regards,

kb