I currently have these headers in my dataset: Item name | Description | Total qty on hand | Ave cost | Total value I'm trying to add the location but having trouble finding the location of the inventory among the many location fields available. Anyone happen to know which one is for location of quantity on hand?

In analytics, the locations inventory is a join, just go to the locations table under the item table and on hand is there.

@Sandii you mean I should create a dataset starting from the location record type and get the inventory from there? The previous dataset I made started from the item record type.

No, I am saying the locations sublist is considered a join in analytics. You start at item and on the left there are joins, click on

locations

and you will see information that is part of the locations sublist.