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.

FLWNPSATarget

Data source: KPILakeAS

evaluate
summarizecolumns
(
'Geography'[Area Short Name], //Target numbers are not supported at subsidiary level.
'Sales Group'[Sales Unit],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Segment'[Field Segment],
'Segment'[SubSegment],
filter('Managed Measure','Managed Measure'[Measure]="Frontline NPSA"),
filter('Calendar','Calendar'[Fiscal Year]>="FY22"),
filter('Segment','Segment'[Field Segment] IN {"Major Commercial","Major Public Sector","Strategic Commercial","Strategic Public Sector","SM&C Corporate"}),
filter('Solution Area','Solution Area'[Solution Area] in {"Modern Work","Modern Work & Security"}),
"Actual",[Actual],
"Target",[Target]
)