Group by Lower Level Product
I am trying to create a simple count by product report. However, I am getting duplicate outputs.
The product hierarchy looks like this:
Product Level 1/Product Level 2/Product Level 3A/Product Level 4
Product Level 1/Product Level 2/Product Level 3B/Product Level 4
I would like to create a report that counts product level 4.
Column 1: products.prod_lvl4_id
Column 2: count(*)
The problem I am having is I get two lines of each product level 4 due to the split at Product Level 3. Is there a way to group everything by the 4th product?