SQL EXAMPLES FOR:
SQL STATEMENT EXAMPLES
sp_report SalesByItemSummary show Quantity_Title, Amount_Title, Percent_Title, AveragePrice_Title, AmountCOGS_Title, AmountAvgCOGS_Title, AmountGrossMargin_Title, PercentGrossMargin_Title, Text, Label, Quantity, Amount, Percent, AveragePrice, AmountCOGS, AmountAvgCOGS, AmountCOGS, AmountGrossMargin, PercentGrossMargin parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'TotalOnly'