Just to let everyone interested know I settled on the following report, it does take some time to generate but the results are good, sales divided by group name:
Cant hurt to have another report give it a try!
@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,} [$1 Sales:7, 2, 2, 3]
{REPORT ORDER DETAILS:O.MenuItemName,OS.NewBook GLA,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$2” and (MG=$1)}
{REPORT ORDER DETAILS:’ ‘+[O.PortionName],’',O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$2” and (MG=$1) and O.PortionName!=“Normal”}Total $1||{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) and (MG=$1)}