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)