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.

TPAccountPipeline

Data source: PipelineAS

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information'[TPID],
'Account Information'[Top Parent],
'Account Information'[Translated Account Name],
'Account Information'[HQ DS Flag],
'Geography'[Area Short Name],
'Geography'[Subsidiary],
'Account Information'[Industry],
'Segment'[Summary Segment],
'Segment'[Segment],
'Segment'[SubSegment],
'Segment'[Field Summary Segment],
'Segment'[Field Segment],
'Segment'[Field SubSegment],
'Account Information'[MAL Flag],
'Sales Group'[Sales Territory],
'Sales Group'[Sales Unit],
'Account Information'[ATS],
'Account Information'[ATU Group],
'Account Information'[ATU Manager],
'Account Information'[AM],
'Account Information'[Vertical Category],
'Account Information'[Vertical],
'Account Information'[Sector],
'MAL'[Inactive Flag],
FILTER('Account Information',NOT(ISBLANK('Account Information'[TPID]))),
FILTER('Solution Area', 'Solution Area'[Solution Area] in {"Modern Work", "Security","Modern Work & Security"}),
FILTER('Calendar', 'Calendar'[Fiscal Year] >= "FY20"),
FILTER('Pipeline Product Allocation','Pipeline Product Allocation'[Product Allocation View] = "Unallocated"),
"Opportunity Count", [Opportunity Count]
)