Try using the analytics workbook you may able to get your data through subsidiary level join and pivot table.