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.
help.appsheet.com - References Between Tables References Between Tables help.appsheet.com
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.
@Francesco_Frosi If you’re using a slice, you need to make sure to include the virtual column in the slice definition. Slices can filter both rows and columns.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |