So would really like to be able to do this on one sheet if its possible. I have a list of inventory across multiple locations, for example:
Location Item Amount
London Peaches 4
Paris Melons 3
London Apples 5
If I have this sheet linked to my tab and chose Location as the list ‘London’ displays twice, I only want it to show once and then be able to click on each location to drill down to the next level. Is there a way I can create a list based on the unique locations in my inventory list with just one sheet?