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.

BizAppsRevenue

Data source: Kpilakepbigsmo

evaluate
summarizecolumns(
'Account Information'[TPID],
'Geography'[Area Short Name],
'Geography'[Subsidiary],
'Account Information'[Global Sales Unit],
'Account Information'[Industry],
'Segment'[Field Segment],
'Segment'[SubSegment],
'BizApps Workload'[Sales Play Category],
'BizApps Workload'[BizApps Sales Play],
'BizApps Workload'[BizApps Work Load],
'Sales Play'[Sales Play],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Business'[Business Summary],
'BizApps Workload Revenue'[Dynamics MAL Plan Flag],
'BizApps Workload Revenue'[Revenue Type],
'Product'[BizApps Product],
'Product'[BizApps Workload],
filter('Calendar','Calendar'[Fiscal Year] >= "FY21"),
filter('Segment','Segment'[Field Summary Segment] IN {"Enterprise Commercial","Enterprise Public Sector","SM&C Corporate","SM&C SMB"}),
"BizApps Total Revenue",[BizApps Total Revenue]
)