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.

TPAccountAzDash

Data source: AzureDashboardAS

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information'[TPID],
'Account Information'[Top Parent],
'Account Information'[HQ DS Flag],
'Geography'[Area],
'Geography'[Subsidiary],
'Account Information'[Industry],
'Segment'[Summary Segment],
'Segment'[Segment],
'Segment'[SubSegment],
'Account Information'[MAL Flag],
'Account Information'[Vertical Category],
'Account Information'[Vertical],
'Account Information'[Sector],
'Account Information'[Sales Unit],
'Account Information'[ATU Manager],
'Account Information'[ATU],
'Account Information'[ATU Group],
'Account Information'[Inactive Flag],
'Account Information'[AM],
FILTER('Account Information', 'Account Information'[Inactive Flag] == "No"),
"TPID Count", [TPID Count]
)