Skip to main content

Item

The Item data model covers item level pricing, costs, and sales history over time. It includes measures like transaction quantity, unit cost, unit price, extended price, extended cost, standard unit cost, standard unit price, average unit cost, total quantity on hand, sold quantity, sold dollars, and sold cost of goods. Use it to compare costs and pricing across items and fiscal years.

How to use this data model​

  • Compare extended and standard costs by year to track how item costs evolve and spot significant changes.
  • Review sales by fiscal year to see what was sold, in what quantity, and at what cost over time.
  • Analyze item level cost breakdowns to compare unit cost, standard cost, and average cost across your product catalog.

Available views​

ViewTypeWhat it shows
Item Costs By YearWorksheetShows item costs broken down by year for budgeting and cost trend review.
Quantity and Value Sold By Fiscal YearWorksheetShows sold quantities and dollars by fiscal year for each item.