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.

CrossSellAdjustedRevenue2

Data source: BizAppsAs

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information'[TPID],
'Account Information'[Top Parent],
'Geography'[Area],
'Segment'[SubSegment],
'Segment'[Segment Group],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Month],
'Calendar'[Fiscal Semester],
'Calendar'[Fiscal Quarter],
'Product'[Biz Apps Cross Sell Service],
'Pricing Level'[Business Type],
'Transaction Type'[Transaction Type],
'Business'[Business Summary],
FILTER('Product', 'Product'[Super Rev Sum Division] in {"Dynamics 365"}),
FILTER('Segment', 'Segment'[Segment Group] in {"Enterprise","SMC - Corporate"}),
FILTER('Calendar', 'Calendar'[Fiscal Year] in {"FY20","FY21"}),
"Cross Sell Adjusted Revenue", [Cross Sell Adjusted Revenue],
"Biz Apps Workload", [Biz Apps Workload]
)