Item Pricing Performance Metrics Dataset Details

This dataset provides details for item pricing, and lets you monitor pricing and margin trends over a specified time period. Use this dataset to focus on pricing problems so you can make the necessary adjustments right away. Prices include line-level and header-level discounts.

Revenue is based on the base currency of the selected parent company or subsidiary.

Dataset Configuration

The item-level pricing dataset combines fields from one record type and one criteria field. To edit the dataset, see Defining a Dataset.

The template is configured as follows:

Root Record Type	Joined Record Types	Custom Formula Fields	Data Grid	Criteria Filters
ItemPrice	ItemPriceLineItem	(none)	The following record fields are included in the dataset: Average Cost Change % Average Profit Margin in Period Average Sold Price Currency Estimated Average Cost in Period Item Period Price Level Price Level Rate Profit Margin Change % Revenue Change % Revenue in Period Sell-Through Rate Change % Sell-Through Rate in Period Subsidiary Target Profit Margin Units Sold in Period	The following criteria is used to filter the dataset: Subsidiary joined with Item Price

Root Record Type

Joined Record Types

Custom Formula Fields

Data Grid

Criteria Filters

ItemPrice

ItemPriceLineItem

(none)

The following record fields are included in the dataset:

Average Cost Change %
Average Profit Margin in Period
Average Sold Price
Currency
Estimated Average Cost in Period
Item
Period
Price Level
Price Level Rate
Profit Margin Change %
Revenue Change %
Revenue in Period
Sell-Through Rate Change %
Sell-Through Rate in Period
Subsidiary
Target Profit Margin
Units Sold in Period

The following criteria is used to filter the dataset:

Subsidiary joined with Item Price

Dataset Configuration

Related Topics