@{REPORT ORDER DETAILS:O.Department::,}
@{REPORT ORDER DETAILS:O.User::,}
[Department Sales By User:1, 1]
>>$1|Total
{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum:(ODI=True):(DE=$1)}
>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True):(DE=$1)}
Am a stuck on how I can Filter by Department and List by User
E.G.
Restaurant
Admin
Soft Drink------------------------------25
Large Drink-----------------------------30
Coffee------------------------------------30
TOTAL--------------------------------85
BAR
Fred
Mosi-------------------------------------------10
Castle-----------------------------------------10
TOTAL-----------------------------------------20
Then add $2 for user constraint.
2 Likes
Thanks this helped to remove the duplicates
Hey, am a bit lost on how to formulate the constraint and where to position
Untested but something like this;
@{REPORT ORDER DETAILS:O.User::,}
@{REPORT ORDER DETAILS:O.Department::,}
[Department Sales By User:1, 1]
>>$1
>>$2 total for $1
{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum:(ODI=True) AND (DE=$2) AND (OU=$1)}
>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) AND (DE=$2) AND (OU=$1)}
>User Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) AND (OU=$1)}
3 Likes
It Works as expected… Thanks
LOL it worked as is? Never?
2 Likes
Report Test|534x639
LOL!!! Unless am over exicted and missed what I actually want…
2 Likes
Probably do with a little refinement but shocked it worked first time just typing it out without testing LOL
3 Likes
very interesting I’m already very interested myself