Report By Specific ItemTag grouped by Department

I’d like to do a data export for specific products that I’ve tagged, grouped by department

What I’ve got is:

Report
Department;Category;Sales
{REPORT ORDER DETAILS:O.Department,O.ItemTag,O.ExactTotal.Sum,::"{0}";"{1}";"{2}"}
;;=SUM(C3:C<row-1>)

That gives me the total as expected, but how would I go about having subtotals for each department?

I was thinking along the lines of:

Report
Department;Category;Sales
{REPORT ORDER DETAILS:O.Department:(DE=Restaurant),O.ItemTag,O.ExactTotal.Sum,::"{0}";"{1}";"{2}"}
;;=SUM(C3:C<row-1>)

to just show for one department.

Also, how would I filter by specific item tags?

 {REPORT ORDER DETAILS:O.ItemTag:(??=Beverages)

Hey vits

One method is to feed the departments used into a @Parameter List and then pipe them into the {REPORT ORDER DETAILS:x} tag:

@{REPORT TICKET DETAILS:T.Department,T.TotalAmount.sum::{0}:,}
>Dept: $1
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum:(DE=$1):{0}|${1}:}

That above is user sales per department.

I have not used tags much so no help there.

1 Like