I have a knowledge base app where i have Article type as a column.
How can get i all the rows from the same table where the article type is the same?
Lets say i have "How to" article type in 10 of 1000 rows. I want when i open an article to see all other rows of the same Article type?
Solved! Go to Solution.
FILTER(Table[Key], [Article type] = [_THISROW].[Article type])
FILTER(Table[Key], [Article type] = [_THISROW].[Article type])
Worked! Thanks!
Just w/o the [key]
FILTER(Table, [Article type] = [_THISROW].[Article type])
Right--of course. I conflated SELECT and FILTER.
User | Count |
---|---|
40 | |
34 | |
30 | |
23 | |
17 |