Issue comparing 2 years revenue data

[agodoo]

Hello,
I would need to compare the revenue of 2 years (2019 and 2018). I want to be able to do such a compare as global revenue and also divided for each sales agent.

In my sample data I have 2 sales agent:
Di Stefano Marco
Ferrario Giovanni
Mussi Giorgio

As you can see from data in sql file, I imagined to have a table with the sales for each month of the 2 years; in each sale record I have the value and the reference to the sales agent.

The main element I imagined to use to the compare the revenue is the Indicator "Fatturato 2019 vs. 2018".
In the indicator the field Sum(vendite_2019.importo) is correct but the Sum(vendite_2018.importo) is not correct. Is a lot bigger. It seems that it breaks after I added the 'relAgenti2018' relation under "vendite_2018'.

Selecting the name of the sales agent, I would need to filter all the data by the agent.

I didn't understand where I'm wrong and if I have to change my data structure.

Kind regards,
matteo

[Lech Kulikowski]

Hello,

Sorry for the delay with the response.

You can use only one data source "vendite", you can add anno columns as Series.

Thank you.