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.

TPMarketingEngagement

Data source: OneGDCOptimizedMEIAs

evaluate
summarizecolumns
(
'Account Information'[TPID],
'Account Information'[Top Parent],
'Account Information'[MEI Reporting Flag],
'Marketing Play Product Map'[Marketing Play Mapped Product],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
filter('Calendar','Calendar'[Fiscal Year]>="FY22"),
filter('Solution Area','Solution Area'[Solution Area] in {"Modern Work","Modern Work & Security"}),
FILTER('Segment','Segment'[Segment] IN {"Strategic Commercial","Strategic Public Sector","Small, Medium & Corporate Public Sector","Small, Medium & Corporate Commercial"}),
"MEI Engagement",[MEI Engagement]
)