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.

OpportunityPipeline

Data source: PipelineAS

EVALUATE
SUMMARIZECOLUMNS
(
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Product'[Dynamics Workload],
'Opportunity'[CRM Opportunity ID],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Business'[Business Summary],
'Pipeline'[Pipeline Category],
FILTER('Solution Area', 'Solution Area'[Solution Area] in {"Business Applications"}),
FILTER('Calendar', 'Calendar'[Fiscal Year] >= "FY20"),
"Qualified Pipeline",[Qualified Pipeline],
"Product Quantity",[Product Quantity],
"Pipeline",[Pipeline],
"Security Qualified Pipeline",[Security Qualified Pipeline]
)