Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

Opportunity

Data source: PipelineAS

EVALUATE
SUMMARIZECOLUMNS
(
'Geography'[Area Short Name],
'Geography'[Subsidiary],
'Account Information'[Top Parent],
'Account Information'[TPID],
'CRM Account'[Account],
'Opportunity'[CRM Opportunity ID],
'Opportunity'[Opportunity Name],
'Opportunity'[Opportunity Created Date],
'Opportunity'[Opportunity Due Date],
'Opportunity'[Opportunity Close Date],
'Opportunity'[MSX Status],
'Opportunity'[CRM Hyperlink],
'Sales Group'[Sales Unit],
'Opportunity'[Days in Sales Stage],
'Sales Stage'[Sales Stage],
'Opportunity'[Forecast Recommendation],
'Opportunity'[Forecast Comments],
'Segment'[Summary Segment],
'Segment'[Segment],
'Segment'[SubSegment],
FILTER('Solution Area', 'Solution Area'[Solution Area] in {"Business Applications"}),
FILTER('Calendar', 'Calendar'[Fiscal Year] >= "FY20"),
"Opportunity Count", [Opportunity Count]
)