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.

BilledRevenueEnrollment

Data source: WWICAS

evaluate
summarizecolumns
(
'Account Information'[Top Parent],
'Account Information'[TPID],
'Incentive Compensation'[Invoice Document Number],
'Enrollment Term'[Enrollment],
'Incentive Compensation'[Enrollment Duration],
'Enrollment Term'[Primary Expiration Date],
'Calendar Billing Coverage Start'[Billing Coverage Start Date],
'Calendar Billing Coverage End'[Billing Coverage End Date],
Calendar[Fiscal Year],
Calendar[Fiscal Quarter],
Calendar[Fiscal Month],
Product[Super Rev Sum Division],
Product[Rev Sum Division],
Product[Rev Sum Category],
Product[Product Family],
'Pricing Level'[Reporting Summary Pricing Level],
'Future Flag'[Future Flag],
'Transaction Category'[Transaction Category],
'Transaction Category'[Transaction SubCategory],
'Product'[Part Number],
'Product'[Part Description],
filter('Product','Product'[Solution Area] in {"Modern Work","Security","Modern Work & Security"}),
"Billed Revenue",[Billed Revenue],
"Billed Licenses",[Billed Licenses]
)