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.

SupportBilledRevenue

Data source: AZ1SINGFIPPDRPT

evaluate
summarizecolumns
(
'Organization Master'[Top Parent ID],
'Sales Group Hierarchy'[Area Name],
'Sales Group Hierarchy'[Subsidiary Name],
'Sales Group Hierarchy'[Sales Unit Name],
'Organization Master'[Industry Name],
'Organization Master'[Vertical Name],
'Organization Master'[Vertical Category Name],
'Std Rptg Reported Subsegment Hierarchy'[Std Rptg Super Reported Subsegment Name],
'Std Rptg Reported Subsegment Hierarchy'[Std Rptg Mid Reported Subsegment Name],
'Std Rptg Reported Subsegment Hierarchy'[Std Rptg Reported Subsegment Name],
'Fiscal Period'[Fiscal Year],
'Fiscal Period'[Fiscal Quarter],
'Fiscal Period'[Fiscal Month],
'Business Hierarchy'[Business Summary Name],
'Pricing Level Hierarchy'[Purchase Type Name],
'Pricing Level Hierarchy'[Reporting Summary Pricing Level Name],
'Business Type'[Business Type],
'Pricing Level Hierarchy'[Detail Pricing Level Name],
'Pricing Level Hierarchy'[Detail User Type Name],
'Primary Product Group Hierarchy'[Primary Product Group Category],
'Primary Product Group Hierarchy'[Primary Product Group],
'Services Support Model'[Support Model],
filter('Operational Metric','Operational Metric'[Operational Metric]="Support Billed Revenue"),
"Actual Revenue",[Actual Amount]
)