MTD Buying Group sales summary (by Title)
(SELECT Month,[Buying Group],Title,Sum([Sales Qty]) AS [SSales Qty],Sum([Sales Value]) AS [SSales Value],Sum([Return Qty]) AS [SReturn Qty],Sum([Return Value]) AS [SReturn Value],Sum([Net Sales]) AS [SNet Sales],Sum([Net Value]) AS [SNet Value] FROM Sales GROUP BY [Buying Group], Title, Month)
False
False
False
 3
{GROUP}
 1
{FIELD}
 0
Buying Group
 5
 0
Buying Group
???
 1
{/FIELD}
{/GROUP}
{GROUP}
 7
{FIELD}
 0
Title
 6
 0
Title
???
 1
{/FIELD}
{FIELD}
 0
SSales Qty
 2
 1
Sales Qty

 0
{/FIELD}
{FIELD}
 0
SSales Value
 2
 1
Sales Value

 0
{/FIELD}
{FIELD}
 0
SReturn Qty
 2
 1
Return Qty

 0
{/FIELD}
{FIELD}
 0
SReturn Value
 2.5
 1
Return Value

 0
{/FIELD}
{FIELD}
 0
SNet Sales
 2
 1
Net Sales

 0
{/FIELD}
{FIELD}
 0
SNet Value
 2
 1
Net Value

 0
{/FIELD}
{/GROUP}
{GROUP}
 1
{FIELD}
 0
Month
 2
 0
Month
[Month]= DateSerial(Year(Now),Month(Now),1)
 1
{/FIELD}
{/GROUP}

end