Is there a way to get inventory values to subtotal by category?

SUGGESTED

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:

  1. Earrings
    1. diamond earrings
    2. gold earrings
    3. silver earrings
  2. Watches
    1. Seiko men's watch
    2. Seiko ladies watch
    3. Swatch watch
  3. Rings
    1. 10k men's ring
    2. 14k men's ring
    3. 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? 

Parents Reply Children
  • 0 in reply to RandyW
    I selected the Grouped List option and chose "Select All". The report showed all inventory items but did not sub-total the $'s for each category.

    I also noticed on the report options there is "Select from", "Report quantities in" and "Grouping". Under Grouping there is an option "No grouping" which is selected but greyed out so I am unable to deselect it. I don't know why it is greyed out and if that is why I am not getting the desired result.
  • 0 in reply to Stephen_B
    As a short term solution you could export the report to Excel and add a subtotal. If this can't be resolved long term you may want to consider using another reporting program such as XLGL to customize your inventory report to give you the information you need.