Forum Discussion
Yet Another grouping question
Hi all! I have some data, defined as: Data_Type Data_Queue Data_Count ABC Car 123 ABC ABC_Count 456 DEF Truck 8 DEF DEF 91 DEF DEF_Count 12 I need to show ONLY ...
Add the column as
Has Word Count = IF( CONTAINSSTRING( Table_WordFilter[Data_Queue], Table_WordFilter[Data_Type] & "_Count") , 1, 0)Or
Has Word Count = IF( Table_WordFilter[Data_Queue] = Table_WordFilter[Data_Type] & "_Count" , 1, 0)Use this column as filter.
Actually....this might work. I'm trying doing a Merge Query to get everything into one table, then applying this. I'll let you know.
This worked with a merged query!