Item sales report by user

V5 Question
21

Forum search is your fried :wink:

[Sales by User:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.Terminal.asc:(ODI=True):,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True) && (TE=$1):{0}:,}
>>$1
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) && (TE=$1) && O.MenuItemName="$2"}
{REPORT ORDER DETAILS:’ '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) && (TE=$1) && O.MenuItemName="$2":2}
22

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?

Thanks

Max

23

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}
1 Like