Skip to main content

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:

Identifying period of time with two sources

 

- The second one is the total sales per month for each shop:

pastedImage_4.png

 

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:

 

pastedImage_9.png

 

Any help would be appreciated. I have attached a sample workbook to this post.

 

Cheers,

Jonas

2 answers
  1. Feb 20, 2018, 11:43 AM

    Hi, Jonas

     

    Please find my solution attached with version 10.2.

     

    Below are steps:

     

    inner join your two data sources as below

     

    Hi, Jonas Please find my solution attached with version 10.2.

     

    Create 3 calculation fields

    pastedImage_1.png

     

    Build your view by using these 3 calculation fields as below

    pastedImage_2.png

     

    Please let me know if you have question

     

    ZZ

0/9000