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?