I setup inventory items using categories. But I can't find a way to show inventory values with category totals. Is there a way to get inventory values to subtotal by category?
I setup a retail jewellery store with the following inventory categories and items:
- Earrings
- diamond earrings
- gold earrings
- silver earrings
- Watches
- Seiko men's watch
- Seiko ladies watch
- Swatch watch
- Rings
- 10k men's ring
- 14k men's ring
- 18k women's ring
Now I want the inventory summary report to give me subtotals for each of the categories. But the report just lists the individual items and value of each item. I can't find a way to get the report to give me sub totals for each category.
Any suggestions?