Departmental Item sales By User Report

@{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

(ODI=True) AND (DE=$1)

Without :

3 Likes

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)}
2 Likes

It Works as expected… Thanks :clap:

LOL it worked as is? Never?

2 Likes

Report Test|534x639
Report Test 2

LOL!!! Unless am over exicted and missed what I actually want… :sweat_smile:

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