Yes. Using the LHR Item Detail Universe, add the following report objects:
This will generate a report breaking down how many items for specific material types are currently present in specific shelving locations.
For further assistance, please see our documentation on creating a query.