Is there a way to total each user as well, right now it lists perfectly the items sold, but is there a way that for each user is a total of the sold items and a total of the value sold?
Nevermind found a solution, just in case somebody is looking for one:
[User Sales Summary:5, 2]
>User|Summary
{REPORT ORDER DETAILS:O.User,=[O.ExactTotal.sum]}
[Detailed Sales by User:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.User.asc:(ODI=True):,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1):{0}:,}
>>$1
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1) and O.MenuItemName="$2"}
{REPORT ORDER DETAILS:' '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1) and O.MenuItemName="$2":2}