Hi ,I followed the tutorial Create Item sale report by Cazz and achieved the kind of reports that i needed. I only added the tag to select the department (DE=Bar)
[Sales:1,2,1,1]
>Item Group|Item|[N]Quantity|[C]Total
{REPORT ORDER DETAILS:O.ItemGroup,O.MenuItemName,O.Quantity,O.TotalPrice:(DE=Bar)}
later i used pivot tables to achieve the results as below
Thanks for the tutorial and i will be keen while using the @mentioning feature.