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.

FieldRevenueAccountabilityForecast

Data source: FinHubAS

EVALUATE
SUMMARIZECOLUMNS(
'Geography - Credited Geography'[Area],
'Geography - Credited Geography'[Subsidiary],
'Sales Group'[Sales Unit],
'Geography - Field Geography'[Field Area],
'Geography - Field Geography'[Field Accountability Unit],
'Geography - Field Geography'[Field Subsidiary],
Segment[Field Segment],
Segment[Field Sub Segment],
'Pricing Level'[Custom Purchase Type],
'Pricing Level'[Reporting Summary Pricing Level],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Product - Field Solution Area'[Field Solution Area],
'Product - Field Solution Area'[Field Commercial Workload],
'Product - Product Group'[Super Rev Sum Division],
'Product - Product Group'[Rev Sum Division],
'Product - Product Group'[Rev Sum Category],
'Product - Product Group'[Product Family],
FILTER(Segment,Segment[Field Forecast Segment] IN {"Major Public Sector","Major Commercial","Strategic Public Sector","Strategic Commercial","SM&C Corporate","SM&C SMB"}),
FILTER('Revenue Taxonomy - Forecast Type','Revenue Taxonomy - Forecast Type'[Forecast Type]="Field"),
FILTER('Revenue Taxonomy - FRA Type','Revenue Taxonomy - FRA Type'[FRA Type]="FRA"),
FILTER('Revenue Taxonomy - Perspective','Revenue Taxonomy - Perspective'[Perspective]="End Customer"),
FILTER('Azure Taxonomy - ACR Adjustment Type','Azure Taxonomy - ACR Adjustment Type'[ACR Adjustment Mid Group]="N/A + Other"),
FILTER('Revenue Taxonomy - Business','Revenue Taxonomy - Business'[Business Summary] IN {"Field","Stores Field","Unassigned"}),
"FieldRevenueAccountabilityForecast",[Field Revenue Accountability Forecast]
)