Hi everyone,
I've problem here I want to build finance report which contains gross sales each product categories, and discount each categoried on a specific time.
But seems the database is only store the discount / rule description like "Tshirt Discount 35%, Tshirt 2016 Discount 25%" on specific order. And I cannot calculate how much the discount for each categories on specific order number.
Anybody knows the walkthrough for this one?
