How do I filter on ItemTag in ORDER DETAILS? Pls help

Greetings Friends,

I have added product tags for some of the products as shown below:

I am trying to make a report to fetch total sales of this product tag. I tried the following, but they did not work:

[Paneer Dishes vs Other Veggies Sales Report: 1, 1, 1, 1]
>Dish|MenuGroup|Qty|Total
Paneer Dishes|{REPORT ORDER DETAILS:O.ItemGroup, O.Quantity.sum, O.Total.sum:(O.ItemTag="Paneer Dish")}

[Paneer Dishes vs Other Veggies Sales Report: 1, 1, 1, 1]
>Dish|MenuGroup|Qty|Total
Paneer Dishes|{REPORT ORDER DETAILS:O.ItemGroup, O.Quantity.sum, O.Total.sum:(MT=Paneer Dish)}

[Paneer Dishes vs Other Veggies Sales Report: 1, 1, 1, 1]
>Dish|MenuGroup|Qty|Total
Paneer Dishes|{REPORT ORDER DETAILS:O.ItemGroup, O.Quantity.sum, O.Total.sum:(MT.Tag=Paneer Dish)}

Could you please tell me the correct filter syntax for this.

Thanks & Regards…

I would add a custom product tag (you add custom tags in a comma separated list in the program settings tab of settings section).
MT is for custom tags.
So if you names the custom tag Type or maybe you would use MT.Type=Paneer Dish

1 Like

thanks for the reply, i tried it out, and it works…