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.

TPCYAdjustedRevenueNPipeline

Data source: BizAppsAs

evaluate
summarizecolumns(
'Account Information'[TPID],
'Geography'[Area Short Name],
'Geography'[Subsidiary],
'Sales Group'[Sales Unit],
'Segment'[Field Segment],
'Segment'[SubSegment],
'Account Information'[Industry],
'Account Information'[Vertical],
'Account Information'[Sub Vertical],
'Calendar'[Fiscal Year],
'Solution Area'[Commercial Workload],
'Product'[C+E Flag],
'Product'[Azure Flag],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Business'[Business Summary],
'Transaction Type'[Transaction Type],
'Future Flag'[Future Flag],
'Pricing Level'[Business Type],
'Pricing Level'[Reporting Summary Pricing Level],
filter('Calendar','Calendar'[Fiscal Year]>="FY23"),
filter('Segment','Segment'[Field Summary Segment] IN {"Enterprise Commercial","Enterprise Public Sector","SM&C Corporate","SM&C SMB"}),
FILTER('Solution Area', 'Solution Area'[Solution Area] = "Business Applications"),
"Adjusted Revenue",[Adjusted Revenue],
"Qualified Pipeline",[Qualified Pipeline],
"Pipeline",[Pipeline]
)