Modify the SP_PER_LOCATION_SALES_REPORT and add Coordinate Group fields and filter for Coordinate Group and Extended Class in all of the hierarchy group filter, also create new query that group by Coordinate Group and replace the table LOCATION_DIM to PER_BRAND_LOCATION_DIM for all of the hierarchy group filter  then add on the SP_PER_LOCATION_SALES_REPORT