How to use data filter for a column with empty cells without deleting the cells?
Sep 11, 2020 10:54 AM
| Last Modified: Sep 16, 2020 4:19 AM(267 views)
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
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.
Thank you for the response I had the same thing that you suggested (one column for Entity, one for Chamber) then I filtered the Entity. The problem in my report is I like to see the graphs based on the different products (Product filter). But Entity filter is separated and when I click on them to chose one, it shows all the products on that Entity. I do not know how to connect them and when I click on an Entity in the filter window I can be able to click on chose the specific product from the product filter window.