Parameter

Option

Entity

Opportunity

Date field

Actual Close Date

Revenue field

Actual Revenue

The correct table is Opportunity because the goal measurement is based on deal amounts when opportunities are closed. In Dynamics 365 Sales goal metrics, rollup fields define which table and source attribute are used to calculate actual or in-progress goal values. Microsoft’s goal metric documentation gives the direct example of using the Opportunity table with the opportunity actual value/source attribute to track actual money amounts from opportunities closed as Won .

The correct date field is Actual Close Date because the goal period must be determined by when the deal was actually closed, not when the opportunity was created. Microsoft’s goal metric configuration guidance states that the Date Field determines the goal period that records roll up into, and gives Actual Close Date as the relevant example.

The correct revenue field is Actual Revenue because the requirement is based on the total deal amount upon closing the opportunity. Budget Amount and Total Amount do not represent the final closed deal value for goal actuals. Goal rollup fields calculate actual performance values for completed measurable results, which fits closed opportunity revenue.

References/topics: Dynamics 365 Sales goals; goal metrics; rollup fields; opportunity actual revenue; actual close date; sales performance tracking.