This is my situation. How can i create the FILTER? The only result is: JUNE, JUNE. I can’t “reach” the “NAME” in table 1. Thank for the tips
@Francesco_Frosi Make your Type column in Table 2 a reference column to Table 1. Then add a virtual column to Table 2 with the formula [Type].[Name]. That makes the name available in Table 2.
Ok ty @tony. but i can’t see the VIRTUAL COLUMN inside a view (or a slice) for the table 2. Why? I only see the REAL COLUMN of the table…
This issue came from the filter. When i filter over TABLE 2, i want to show the name referenced in table 1, but i can see only real columns.