Finance report

[mohmrt]

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?

[Dmitry_Fedyuk]

How to get an order item's discount amount programmatically? https://mage2.pro/t/546

[exto_io]

Have a look at Exto Analytics: exto.io/exto-analytics-for-magento-2.html

It can answer the question with no additional programming, it's free for M2 CE