Report / BOM by location

  How do I create a report based from location?  In the report  I only want items from one location to show up. 

Below is a screen shot of my attempt to create the report.  Unfortunately it shows all components across all locations.  This report shows all the components by the “location identifier”.  You will notice item 10 has two location identifiers – “2739, 2843”?  How do I get these to show up on two separate line items with the appropriate quantities?  

SolidworksElectrical