Tag Wise Item Sale Report

Ok, so tested and looks like you cant use the Tag column for constraint.
Simple answer is create a popper menu item/product tag column for this ‘setting’ - call it whatever, ‘Department’

That will give you a 'Department column here;

Move your Food/Bar from Tag to ‘Department’

Then use

{REPORT ORDER DETAILS:O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(MT.Department=Bar)}

1 Like

Hey, it worked

thank you

1 Like

If you wanted to learn and get creative you could try using an @ expression and $1.

@Food,Bar
[$1 Sales by Amount:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(MT.Department=$1)}
> |Total||{REPORT ORDER DETAILS:O.Total.Sum:(ODI=True)&&(MT.Department=$1)}

In theory you would use a report expression for the @ too to make it truly dynamic.
The @ declairs a list which is the ‘mail merged’ into the report, repeating the report for each value in the list and the value is represented by the $1.

Not tested that as on phone but should give you the idea.

Thank you.
will try that…