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
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…