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.

DeviceSellThruRevenue

Data source: OneDevicesAS

evaluate
summarizecolumns
(
'Source MSS - Account'[Distributor TPID],
'Source MSS - Account'[Distributor Top Parent],
'Source MSS - Account'[TPID],
'Source MSS - Account'[Top Parent],
'Source MSS - Account Sold To'[TPID Sold To],
'Source MSS - Account Sold To'[Top Parent Sold To],
'Source MSS - Account Sold To'[NRO Flag],
'Common Date'[Fiscal Year],
'Common Date'[Fiscal Quarter],
'Common Date'[Fiscal Month],
'Source MSS - Std Rptg Reported Subsegment'[Std Rptg Reported SubSegment],
'Source MSS - Std Rptg Reported Subsegment'[Std Rptg Mid Reported SubSegment],
'Source MSS - Std Rptg Reported Subsegment'[Std Rptg Super Reported SubSegment],
'Common Product'[Super Rev Sum Division],
'Common Product'[Rev Sum Division],
'Common Product'[Rev Sum Category],
'Common Product'[Product Family],
'Common Product'[Premium Flag],
'Common Product'[Bundle Flag],
'Common Product'[SKU Type],
'Common Geography'[WW Area],
'Common Geography'[WW Sub Region],
'Common Date'[Sales Date],
'Common Geography'[Credited Sales Location],
'Source MSS - Business'[Business Summary],
'Common Geography'[Credited Area],
'Common Product'[Super Division],
'Common Product'[Product Division],
'Source MSS - Std Rptg Reported Subsegment'[Devices Summary Segment],
'Source MSS - Std Rptg Reported Subsegment'[Devices Super Segment],
'Source MSS - Std Rptg Reported Subsegment'[Devices SubSegment],
FILTER('Advanced Data Version','Advanced Data Version'[Adv Data Version]="Actuals"),
"Sell-Thru Billed Revenue", [Sell-Thru Billed Revenue],
"Sell-Thru Licenses", [Sell-Thru Licenses]
)