Product inventory levels at the Store, or Warehouse/Distribution Center (DC) level can be seen in Performance Analytics by adding two On Hand metrics in just a few steps!

💡The TY UNITS OH STORE (This Year Units On Hand - Stored at Brick and Mortar Stores) and TY UNITS OH WAREHOUSE (This Year Units On Hand - Stored at the Warehouse or Distribution Center) metrics are only available in a To-Date style of report in Performance Analytics.

Below are the full steps when creating a To-Date report from scratch as a Power User.

Step	Instruction	Image
1	Open a To-Date report.
2	After making selections on the prompt screen and running the report, open the Location Folder and add in Retailer and SPS_Location_Type to the PAGE-BY axis.
3	Open the To-Date Analysis Metrics folder > Week to Date folder > This Year folder
4	Scroll down and click on Next 60 items.
5	Double-click to add in: TY UNITS OH STORE TY UNITS OH WAREHOUSE
6	Add in any other metrics or attributes desired for your report. (Ex: Style, Style Description and UPC).
7	Click on the Spreadsheet with Lightning Bolt Icon in the upper left-hand corner to run the report.
8	To see TY UNITS OH STORE, update the SPS_Location_Type to STORE.
9	To see TY UNITS OH WAREHOUSE, update the SPS_Location_Type to any option different than STORE. E.g., WAREHOUSE, DISTRIBUTION CENTER, INTERNET or OTHER.