I want to make a filter in my report for a column that has a few empty cells. Other cells have the name of products. When I use Data Filter, nothing shows up in the report and I think it is because of empty cells. I tried to exclude them but did not work
Add Filter( columns( :Entity1, :Entity2, Where( :Entity1 != "" ), Where( :Entity2 != "" ), ), Display( :Entity1, Size( 120, 100 ), List Display ), Display( :Entity2, Size( 120, 100 ), List Display ) );
Removed at Discussion Author's request
I already have made the same one. the problem is those (???) are messed up. they are joined between columns since there are empty rows in each column and for some reason, they are filled with the data from the second column in the same row numbers.
See the attachments
Based up the first sceen capture of your data table and then the capture of your report, it is my opinion think the data table was created with a split or a poor join.
I think your report and filter would work better if there was one column Product and a different column for Entity etc.