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.

TPAccount

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS
(
'MAL'[TPID],
'MAL'[Top Parent],
'MAL'[Translated Account],
'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],
'MAL'[ATU Group],
'Account Information'[ATU Manager],
'Account Information'[AM],
'Account Information'[GSIFI],
'Account Information'[GSIFI Flag],
'Account Information'[Vertical Category],
'Account Information'[Vertical],
'Account Information'[WWPS Flag],
'Account Information'[Inactive Flag],
'MAL'[MAL Penetration Eligible Flag],
'Account Information'[GPID],
'Account Information'[Strategic GPID Flag],
'Account Information'[Premier Flag],
FILTER('MAL',NOT(ISBLANK('MAL'[TPID]))),
"Account Information", [TPID Count]
)