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.

TPMWSeats

Data source: KPILakeMWAS

evaluate
summarizecolumns
(
'MAL'[TPID],
'Geography'[Area Short Name],
'Geography'[Subsidiary],
'Segment'[SubSegment],
'MAL'[Sales Unit],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Solution Area'[Modern Workplace Grouping],
'Solution Area'[Commercial Workload],
'Product'[MW Grouping Level 1],
'Product'[MW Grouping Level 2],
'Product'[MW Grouping Level 3],
'Product'[MW Grouping Level 4],
'Product'[MW Grouping Level 5],
'Product'[MW Grouping Level 6],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Product'[IW Count flag],
'Transaction Type'[Transaction Type],
'Transaction Type'[Detail Transaction Type],
filter('Solution Area','Solution Area'[Solution Area] IN {"Modern Work","Security","Modern Work & Security"}),
filter('Calendar','Calendar'[Fiscal Year]>="FY20"),
"MW EOP Seats",[MW EOP Seats],
"Initiated Units",[Initiated Units],
"Initiated Units w FLWFlag",CALCULATE([Initiated Units],KEEPFILTERS('Revenue'[FLWFlag]=1)),
"Adjusted Licenses",[Adjusted Licenses],
"IW Count",[IW Count],
"Assigned Units",[Assigned Units]
)