This scenario is a basic inventory example for tracking product quantities. In this walk-through, we'll open a summary of our product categories and total quantities. We will then drill into the Inventory Detail tab to view specific products within that category. There is also a secondary inventory option which allows us to view all of the categories, and the products within them, in a single sheet.
We can go directly to any section of this walk-through by clicking one of the links below.
Navigating to the Inventory Reports
Step 1: Navigate to the Inventory report page inside the INTERJECT Demos folder of the Report Library . The Report Library is a central place for publishing reporting templates. It is versioned and centrally located.
Step 2: Check inventory by opening the workbook to see the different categories available.
To access the totals of in-stock items, just pull the data into the spreadsheet using the "Pull Data" operation.
Now we have an overview of totals for all inventoried categories, as seen below.
In this example, though, we need to find out more than the total; we need to see how much grain we have, which means we need more a detailed view of current inventory.
To find the data, we use the Drill function for inventory by detail.
Drilling to the Detail
Step 1: To drill all we have to do is select the category we want to drill to then give it a double click. For this example, we are going to drill on “Grains/Cereals.” In this instance we use the hyperlink drill which only requires the click of the mouse to be drilled on. Click here to read more on Drills.
Drilling will take us to InventoryByDetail, which will automatically pull all the items in stock within that category.
From here, we can see exactly what is logged in-stock at the time of the pull: "Grains/Cereals" in this example.
Return From Drill and Re-Drill
We also need to gather a report of our beverage inventory.
"Return From Drill"
Button to go back to the sheet we drilled from.
This will bring us back to the previous tab.
Step 2: Now we repeat the steps from the first drill by clicking the Beverages category. Since this is a hyperlink drill the report will automatically take us deeper.
This will automatically pull the detail page again, but this time with products from the new category selected in the previous step.
Alternate Inventory Example
Now we want a report that shows all the categories and their details in one sheet, without having to drill back and forth between the two sheets. To accomplish this, we're going to use InvByCategory_WithDetail.
Step 1: We need to open the WithDetails tab.
When cleared, the sheet looks similar to the first category sheet.
Step 2: Simply pull the data using the "Pull Data" button to view the inventory data.
Now we can view every category and its detail all in one page, without any drills.
That's all there is to it. To learn more about modifying this report, click here .