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

View	Type	What it shows
Item Costs By Year	Worksheet	Shows item costs broken down by year for budgeting and cost trend review.
Sold By Fiscal Year	Worksheet	Shows sold quantities and dollars by fiscal year for each item.
Extend By Item	Radar Spline	Compares extended pricing across items in a radar chart to see relative price distribution.
Ext & Std By Year	Stacked Spline	Compares extended and standard costs by year, showing how they trend together over time.
Ext Price Cost By Year	Stacked Bar	Shows extended price and cost by year as stacked bars for year over year comparison.
Std & Normal Costs By Item	Stacked Radar	Compares standard and normal costs across items in a radar chart to spot cost differences.