Forum Discussion
Dynamically Filter 2 Columns ( both containing lists) and categorize into a slicer
Hi Everyone, I've spent quite some time on this issue and searched the forums/internet and have been unable to find a solution. I'm trying to create a slicer that looks at 2 columns (containing li...
Anonymous , if they are not overlapping then you can have new column like
New column = Switch( True() ,
(search("a", [ListA],,0) > 0 && search("y", [ListB],,0) > 0 )|| (search("a", [ListB],,0) > 0 && search("y", [ListA],,0) > 0 ),"Group A" ,
(search("c", [ListA],,0) > 0 && search("y", [ListB],,0) > 0 )|| (search("y", [ListB],,0) > 0 && search("y", [ListA],,0) > 0 ),"Group A" ,
// add others
)
I've added the new column to the the slicer it only shows 2 visible groups, unfortunately this does not seem to be a solution.
Is it possible to concatenate the two columns and search it for "a" and "y"? If so, how would that code look (it seems fairly complex)?