We are a business that is live in 10+ countries and I would like to create a simple Sales vs. Costs pivot view report broken down into country levels in Odoo 12. The data I need in the report:

1. Sales performance in €.

2. Sales performance in pieces sold.

3. Costs - based on Vendor bills/Invoices.

The first two points are no issue to set up under Sales -> Reporting -> Sales -> Sales Analysis. Here, with the help of filters I set up a report, which shows sales performance in € and pieces per week per country.

However my issue is to incorporate cost data into this above mentioned report. The data source for this would be my Vendor Bills/Invoices.

As far as I know it's possible to combine different data sources using an Analytic Account. 

I set up Analytic Accounts for all countries and assigned them to the right vendor bills/invoices.

Now I'm a bit stuck and would like to get some guidance on how to actually create one report that contains the above mentioned already existing sales report AND the vendor bills data.

I hope this is a clear enough explanation, let me know if I should further describe any detail.

All support/tips are highly appreciated!

Thank you very much in advance.