Issue with values in table visualisation

Hello all

I have data sitting in 2 data tables as below:

Table 1

Date         Till     SalesOpening

1/9/2019  AO1   45

2/9/2019  AO1   78

Table 2 

Date          Till    SalesClosing

1/9/2019   AO1  55 

1/9/2019   AO1  65

I have created a relationship between dates which works when I use the table visualisation, however i get the result below:

Date          Till     SalesOpening     SalesClosing

1/9/2019   AO1   45                       120

The Closing values automatically sum, but I would liek the below:

Date          Till     SalesOpening     SalesClosing

1/9/2019   AO1   45                       55

1/9/2019   AO1   45                       65

Essentially listing all closing values, whilst retaining the singular opening value.

Is this possible?

Thanks for all your advice.