Hello Everybody,
I would need some help.
I have 2 different sources:
- The first one is a list of different shops where price activities are done on fruits with the sales linked to it during the period of the activity:
- The second one is the total sales per month for each shop:
I would like to flag (ie. color) on the second graph the months when activity are implemented as well as which activities on which fruit.
Here is an idea of what I would expect:
Any help would be appreciated. I have attached a sample workbook to this post.
Cheers,
Jonas
Hi, Jonas
Please find my solution attached with version 10.2.
Below are steps:
inner join your two data sources as below
Create 3 calculation fields
Build your view by using these 3 calculation fields as below
Please let me know if you have question
ZZ