Forum Discussion
Solved
Apply filter from two columns
Hi - I have two tables each containing a "Status" column. I created a pie chart with data from both tables. Now I want to create one filter with the "Status" of both tables - Open or Closed. I ...
Hi,
You should create a third table with only 1 column which should list all unique status entries. Then create a many to one relationship from the Status column of both tables to the status column of the third table. To your visual, drag the Status column from the third table.
Hope this helps.
Worked like charm! Thank you!
You are welcome.