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.

CFOForecast

Data source: MSBilledPipeline

EVALUATE
SUMMARIZECOLUMNS
(
'Account'[Area],
'Account'[Subsidiary],
'Account'[Sales Unit],
'Segment'[Sub Segment],
'Segment'[Field Segment],
'Business'[Business Summary],
'Pricing Level'[Business Type],
'Pricing Level'[Reporting Summary Pricing Level],
'Product'[Commercial Workload],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
FILTER('Product', 'Product'[Solution Area] in {"ISD", "Support"}),
filter('Calendar', 'Calendar'[Fiscal Year]>="FY21"),
"CFO Forecast",[Billed Forecast]
)