select * from Orders where Freight > 570
GO
.setPivotResultSettings 'Index=1,
	RowFields="[ShipCountry] {None,SummaryCount,GrandCount} DESC,[ShipCity] {None,SummaryCount,GrandCount} ASC,[ShipRegion] {None,SummaryCount,GrandCount} ASC",
	DataFields="[Freight] {None,SummaryMean,GrandMean} DESC,[ShipVia] {None,SummaryCount,GrandCount} ASC,[ShippedDate] {None,SummaryMax,GrandMax} ASC,[ShipAddress] {None,SummaryCount,GrandCount} ASC,[ShipName] {None,SummaryCount,GrandCount} ASC,[ShipPostalCode] {None,SummaryCount,GrandCount} ASC,[OrderDate] {None,SummaryMax,GrandMax} ASC",
	ShowChart=false,
	ShowToolbar=true,
	Paging=true,
	Split=425,
	Chart="{column,column,column,column,column,column,column}",
	RotX=325,
	RotY=0,
	RotZ=0,
	ZoomScalar=1.0,
	ShowLegend=true,
	ShowLegendBorder=true,
	ShowGrid=true,
	FillGrid=true,
	GridLineWidth=1.0,
	Title="",
	TitlePosition="Bottom Center",
	TitleCategory="",
	TitleValue="",
	PieExplode=0.0,
	GroupSmallValues=true,
	SmallValuesThreshold=3.0,
	PieLabelDistance=3.0,
	PieShowLines=false,
	LineWidth=1.0,
	ShowMarkers=true,
	MapShowBackground=false,
	MapShowDetails=false,
	MapRange="",
	MapRangeColors="",
	Width=16.0,
	Height=10.0,
	Depth=5.0,
	SeriesSpacing=1.0,
	CategorySpacing=1.0,
	Font=ARIAL-BOLD-10,
	LegendFontSize=1.0,
	SeriesFontSize=1.0,
	CategoryFontSize=1.0,
	ValueFontSize=1.0,
	TitleFontSize=1.75,
	AxisTitleFontSize=1.25,
	DataLabelFontSize=1.0,
	TopColor=#ebf0f5,
	BottomColor=#d7dcf5,
	PanX=0.0,
	PanY=0.0,
	Lighting=Default,
	Opacity=1.0,
	View2D=false,
	FitChartToImage=false,
	StackedPercent=false,
	ShowValueAxis=true,
	ShowValueAxisTicks=true,
	ShowValueAxisLines=true,
	ReverseValueAxis=false,
	ShowCategoryAxis=true,
	ShowCategoryAxisTicks=true,
	ShowCategoryAxisLines=true,
	ShowSeriesAxis=true,
	ShowDataLabels=false,
	ValueAxisNumberFormat="",
	CategoryAxisNumberFormat="",
	CategoryAxisDateFormat="",
	CategoryAxisDateTimeFormat="",
	CategoryAxisTimeFormat="",
	SeriesAxisNumberFormat="",
	SeriesAxisDateFormat="",
	SeriesAxisDateTimeFormat="",
	SeriesAxisTimeFormat="",
	NumericCategoryAxis=false,
	MergeAxis=true,
	SeriesAlias="default,default,default,default,default,default,default",
	SeriesSubType=",,,,,,",
	SeriesColumnType="Cube,Cube,Cube,Cube,Cube,Cube,Cube",
	SeriesMin="default,default,default,default,default,default,default",
	SeriesMax="default,default,default,default,default,default,default",
	SeriesColor="#40699d,#9f413e,#809b48,#6a5286,#3c8ea4,#cd7b38,#4f82be",
	SeriesFunctionMetaData="true,true,true,true,true,true,true",
	ShowSeriesDataLabels="false,false,false,false,false,false,false",
	LegendPosition=Top Right,
	LegendWidthType=Fit,
	LegendWidth=100,
	LegendHeightType=Fit,
	LegendHeight=160,
	ShowFixedCategoryCount=false,
	FixedCategoryCount=0,
	ShowFields=true,
	ShowTotal=true,
	ShowSubTotal=false' 
