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.

BilledBudget

Data source: PipelineAS

EVALUATE
SUMMARIZECOLUMNS
(
'Solution Area'[Solution Area],
'Solution Area'[Commercial Workload],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Geography'[Area],
'Geography'[Subsidiary],
'Segment'[Summary Segment],
'Segment'[Segment],
'Segment'[SubSegment],
'Segment'[Field Segment],
'Solution Area'[MW Cloud Proxy Flag],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Sales Group'[Sales Unit],
'Business'[Business Summary],
FILTER('Solution Area','Solution Area'[Solution Area] in {"Modern Work","Security","Modern Work & Security"}),
"Billed Revenue",[Actual Billed Revenue]+[Scheduled Billed Revenue],
"Actual Billed Revenue",[Actual Billed Revenue],
"Scheduled Billed Revenue",[Scheduled Billed Revenue],
"Qualified Pipeline",[Qualified Pipeline],
"Committed + Risk Pipeline",[Committed + Risk Pipeline],
"Run Rate Projections",[Run Rate Projections],
"Billed Budget",[Billed Budget],
"Security Billed Budget",[Security Billed Budget],
"Security Billed Revenue",[Security Billed Revenue],
"Security Qualified Pipeline",[Security Qualified Pipeline],
"Security Committed + Risk Pipeline",[Security Committed + Risk Pipeline],
"Security Run Rate Projections",[Security Run Rate Projections],
"Security Actual Billed Revenue", CALCULATE([Security Billed Revenue],'Future Flag'[Future Flag]="N/A"),
"Security Scheduled Billed Revenue",CALCULATE([Security Billed Revenue],'Future Flag'[Future Flag]="Scheduled"),
"DealBasedCommittedAndRiskPipeline",CALCULATE([Committed + Risk Pipeline],FILTER('Pipeline','Pipeline'[Pipeline Category]="Deal Based Pipeline"))
)