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.

TPExpiration

Data source: WCSAS

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information Primary'[TPID Primary],
'Geography'[Area],
'Geography'[Subsidiary],
'Segment Primary'[Summary Segment Primary],
'Segment Primary'[Segment Primary],
'Segment Primary'[SubSegment Primary],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Calendar Expiration'[Expiration Year],
'Calendar Expiration'[Expiration Quarter],
'Calendar Expiration'[Expiration Month],
'Account Information Primary'[Super TPID Primary],
'Enrollment Term'[Enrollment],
'Enrollment Term'[Duration Years for Annualized C],
'Account Information Primary'[Industry Primary],
'Account Information Primary'[Vertical Primary],
'Account Information Primary'[Sub-Vertical Primary],
'Account Information Primary'[Sales Unit Primary],
'Pricing Level'[Pricing Level],
'Pricing Level'[Reporting Summary Pricing Level],
'Pricing Level'[Detail Pricing Level],
'Enrollment Term'[Federal Deal Flag],
'Segment Primary'[Summary Segment Custom Primary],
FILTER('Calendar Expiration', 'Calendar Expiration'[Expiration Year] >= "FY22"),
FILTER('Product','Product'[Solution Area] = "Business Applications"),
"SA Expiration $",[SA Expiration $],
"Expiration Total $",blank(),
"MS Sales Amount C without L",[MS Sales Amount C without L],
"MS Sales Licenses",[MS Sales Licenses],
"In Quarter Renewal $",[In Quarter Renewal $]
)