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.

FieldRevenueAccountability

Data source: KPILakeSummaryAS

evaluate
summarizecolumns
(
'Account Information'[TPID],
'Geography'[Area Short Name],
'Geography'[Subsidiary],
'Segment'[Field Segment],
'Segment'[SubSegment],
'US Commercial OU'[Is Federal],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'FRA Type'[FRA Type Detail],
'Business'[Business Summary],
'Pricing Level'[Custom Purchase Type],
'Pricing Level'[Reporting Summary Pricing Level],
filter('Calendar','Calendar'[Fiscal Year] IN {"FY21","FY22","FY23","FY24"}),
filter('Segment','Segment'[Field Segment] IN {"Strategic Commercial","Strategic Public Sector","Major Commercial","Major Public Sector","SM&C Corporate"}),
"Field Revenue Accountability",[Field Revenue Accountability]
)