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…