I would like to generate Magento native report as follows:
Can anybody provide the SQL query for above table ?
- Column Name CustomerGender = customer attribute
- Column Name Group = Customer Group native feature
- Grand Total = Grand total from Sales order table
Went through plenty of the links but got regular simple joins.