Historical Item Pricing Performance Dataset Details

This dataset provides source data for the item pricing performance workbook and pricing recommendations. It analyzes configured price-level pricing alongside realized transaction pricing by item, exact monthly period, currency and subsidiary context, and price level. Realized transaction metrics are calculated only from transactions that use the represented price level.

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

Dataset Configuration

The historical item pricing performance 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 Profit Margin in Period

  • Average Sales Rate

  • Estimated Average Sales Cost

  • Item

  • Period

  • Price Level

  • Price Level Rate

  • Revenue

  • Sell-Through Rate

  • Subsidiary

  • Target Profit Margin

  • Units Sold

The following criteria is used to filter the dataset:

  • Subsidiary joined with Item Price

Related Topics

General Notices