Tables interacting with each other

[Anonymous]

Hello all

I have 2 tables on my report, both looking at different aspects of the same data.

Table 1 looks at an address and a date on which they contacted us.

Table 2 has multiple columns showing why they contacted us.

Currently when i select an address in Table 1, Table 2 changes to reflect only the contact that the selection in Table 1 refers to.

I would like Table 2 to show all contacts from that address when I select an address in Table 1.

For example:

Table 1

Address             Date (UK)

123 Fake St        1/11/2019

124 Fake St        2/11/2019

125 Fake St        3/11/2019

123 Fake St        4/11/2019

When I select the first 123 Fake St record, Table 2 updates to show:

Address            Date               Reason

123 Fake St       1/11/2019      Oranges

Whereas I would like it to show:

Address            Date                 Reason

123 Fake St       1/11/2019        Oranges

123 Fake St       4/11/2019        Pears

How can I achieve this (bearing in mind I have to keep the 2 tables separate)

As an extra bonus, I would love Table 2 to show blank until a selection in Table 1 is made if that is also possible?

Any help would be appreciated.

Daniel

[v-diye-msft]

Hi @Anonymous 

What does Table 2 like? if just add the additional column "Reason" based on Table 1? Is the relationship established between them?

[Anonymous]

Hello both

Probably should clarify, when I refer to Table in ym example above, I mean the table visualisation. All the data for both visualations comes from 1 table.

@v-diye-msft @Anonymous 

[Anonymous]

Dont you have a key that you can relate between the tables?

BR,

DR