Merging items Categories in A single report

Hello everyone,

I have a long category list of drinks, foods and tobacco.
Can someone help me with a report where i can merge all the all list of category into the following:
All drinks(Alcohol/Non Alcohol) go under the category Beverages
All Foods(Starters/Main Course/Side dishes) go under the Category Food
All Tobacco(Cigarettes/Cigar/Shisha) go under the Category Tobacco.

Thank you.

Add a custom product tag in the program settings tab under product tags I think it calls the gold.
This will give you a new field on the edit product page fill this field using product tage editor for all products then split your reports using the product tag.

Follow what JTR told you and after tagging all the products with tags you can use this report.

[Summary Report:1, 1, 1]
>Category|%|Total
{REPORT ORDER DETAILS:M.Tag,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True)}
>>Grand Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True)}

Looks something like this.
image

P.S. the reason one category is missing because I have some items that havent been tagged yet.

1 Like