How to sort an inventory log by Location

So hopefully I can explain this succinctly and thanks to anyone willing to help

I have a table with a list of “Products”
I have an inventory table that logs the product being added and subtracted. With each log you need to specify the location of the item. (You can have multiple locations for one item SKU)

I would like to be able to show a table on the product detail which shows the inventory qty in each location, only showing locations which house that specific item

Im able to get a list of unique locations which show qtys although i cant filter the list to show only locations which contain that prodocut

Hopefully that was semi understandable

Hi @Corey_Busuttil
What are you doing to “get the list of unique locations which show qtys”?