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.

TPEADiscount

Data source: WCSAS

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information Primary'[TPID Primary],
'Account Information Primary'[Super 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 First Billed'[First Billed Year],
'Calendar First Billed'[First Billed Quarter],
'Calendar First Billed'[First Billed Month],
'Enrollment Term'[Enrollment],
'Enrollment Term'[Duration Years for Annualized C],
'EA Discount'[Ramped Flag],
'Enrollment Term'[Federal Deal Flag],
'Account Information Primary'[TSI Flag Primary],
'Enrollment Term'[Ramped Enrollment Flag Source],
'Enrollment Term'[BD Touch Flag],
FILTER('Calendar First Billed', 'Calendar First Billed'[First Billed Year] >= "FY22"),
FILTER('Product','Product'[Solution Area]= "Modern Work & Security"),
"List Price Amount",[List Price Amount],
"Contract Value",[Contract Value],
"Discount Amount",[Discount Amount],
"Discount Percentage",[Discount Percentage],
"MS Sales Quantity",[MS Sales Quantity]
)