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
)
This is a more accurate depiction of the fields. When i ran the code I was only seeing 2 groups in the slicer versus the desired 5. Any troubleshooting assistance would be greatly appreciated. Thanks in advance