The only way to accomplish this is by sql and by looking at the history table and looking at what the status changed from, then joining back to the defects table on the entity id for that specific defect. Also the history needs to be enabled for the defect status field in customization.
Here is an example of how you could accomplish this in a QC excel report:

Note: This is just an example, you will need to modify this to fit your needs

SELECT BG_BUG_ID as 'Bug Number', BG_STATUS as 'Bug Status', BG_Responsible as 'Responsible', BG_SUMMARY as 'Bug Summary', BG_DETECTED_BY as 'Detected By'
FROM AUDIT_PROPERTIES
RIGHT JOIN AUDIT_LOG
ON AUDIT_PROPERTIES.AP_ACTION_ID=AUDIT_LOG.AU_ACTION_ID
Left Join BUG
On AUDIT_LOG.AU_ENTITY_ID=BUG.BG_BUG_ID
where ((AP_OLD_VALUE='Reopen' and AP_NEW_VALUE='Fixed') or (AP_OLD_VALUE='Reopen' and AP_NEW_VALUE='Closed')) and AU_ENTITY_TYPE='BUG' and AP_FIELD_NAME='BG_STATUS'

Hi, I am searching for a query which gives the output in following format:

phase | #Defects Reopened | #Defects Rejected | #Total Defects Closed| # Total Defects
SIT XX XX XX XX
ST XX XX XX XX

Thanks
xylo