Price Variance by Item Pivot Details
This pivot table gives you a comprehensive view of sales variance across all items by comparing expected pricing to transaction results. For each item, the pivot highlights:
-
The difference between the Expected Rate and the Calculated Rate
-
The resulting variance in total sales amount over a selected period
When you can see rate and amount variance side by side for every item, you can quickly identify where pricing is falling short. You can understand the financial impact and spot patterns across your full product catalog. This comprehensive view makes it easier to pinpoint missed revenue opportunities and take action to improve pricing accuracy and overall sales performance.
This pivot table contains the following rows and measures:
|
Label |
Contents |
|---|---|
|
Item |
Item sold on the transaction line. |
|
Transaction |
Transaction record reference used for drill-down to the source record. |
|
Price Level |
Price level name. |
|
Trans. Rate |
Rate on the transaction line. |
|
Calculated Rate |
Net Amount ÷ Quantity. |
|
Quantity |
Quantity sold on the transaction line. |
|
Label |
Contents |
|---|---|
|
Expected Amount (Sum) |
Total of the Expected Amounts (Transaction Rate × Quantity). |
|
Net Amount (Sum) |
Total of the net amounts for all transaction lines (Net Amount = Amount - Posting Discount). |
|
Variance Amount (Sum) |
Total of the Variance Amounts (Variance Amount = Difference between revenue and expected amount). |