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.

OpportunityEx

Data source: PipelineAS

EVALUATE
SUMMARIZECOLUMNS
(
'Opportunity'[CRM Opportunity ID],
'Segment'[Field Primary Segment],
'Segment'[Field Super Summary Segment],
'Segment'[Field Segment],
'Segment'[Field SubSegment],
'Opportunity'[Opportunity Desc],
'Opportunity'[Created By],
'Opportunity'[Created By Group],
'Opportunity'[CreatedByStandardTitleGroup],
'Opportunity'[Opportunity Owner],
'Opportunity'[Opportunity Owner Standard Title],
'Opportunity'[Ownership Group],
'Opportunity'[Pending Close Status],
'Opportunity'[Primary Partner Name],
'Opportunity'[Primary Competitor],
'Opportunity'[Compete Threat Level],
'Opportunity'[Licensing Program],
'Opportunity'[Licensing Sub Type],
'Opportunity'[Workload Type],
'Opportunity'[Workload Capability],
'Opportunity'[Workload Detail],
'Opportunity'[Close Plan],
'Pipeline'[GBB Attach Flag],
'Opportunity'[Primary Solution Area],
'Opportunity'[Other Competitor],
'Opportunity'[Sales Play Checklist],
'Pricing Level'[Detail Pricing Level],
'Pricing Level'[Summary Pricing Level],
'Pricing Level'[Reporting Pricing Level],
'Pricing Level'[Reporting Summary Pricing Level],
'Pricing Level'[Business Type],
'Opportunity'[Qualified Pipeline Flag],
'Opportunity'[Price List Type],
'Opportunity'[Opportunity Modified Date],
'Opportunity'[Forecast Comments Modified By],
'Opportunity'[Forecast Comments Modified Date],
'CRM Account'[Account],
FILTER('Solution Area', 'Solution Area'[Solution Area] in {"Business Applications"}),
FILTER('Calendar', 'Calendar'[Fiscal Year] >= "FY20"),
"Opportunity Count", [Opportunity Count]
)