Add a virtual column with (vlookup) data from another table

[Anonymous]

Hello all,

I have two tables with the same keyfield.

Table_1 contains facts and the keyfield exist more than one time.

Something like this:

Key, Dimension, Value
1011322|2 WA 4004.28
MR181152|5 OI 35.23
MR181152|5 WA 1366.06
MR189911|7 OI 70.32
MR189911|7 WA 858.08
MR20009222|2 WA 164.58
MR20014782|2 SVO 112.5
MR20014782|2 SVI 135
MR20014782|2 WA 584.34
MR20015293|4 WA 987.48

Table_2 contains the number of objects on a certain date.

In my dashboard i use a single select on the Date field. So, every keyfield exists once after the selection.

The table looks like this:

Key, Date, NoOfObjects
1011322|2 1/31/2021 98
MR181152|5 1/31/2021 1
MR189911|7 1/31/2021 1
MR20009222|2 1/31/2021 2
MR20014782|2 1/31/2021 2
MR20015293|4 1/31/2021 12

What i want is to add a calculated column to add the number of objects, 'on the fly', to Table_1.

Everytime that the user changes the Date selection, the column must change.

Thanks for your help,

Halmar

[lbendlin · Accepted solution]

What i want is to add a calculated column to add the number of objects, 'on the fly', to Table_1.
Everytime that the user changes the Date selection, the column must change.

Calculated columns are immutable. They cannot be influenced by user filter choices. Rethink your requirement.