How to filter with column name of the table view/Excel having multiple words with space in between.
I have an excel sheet which need to be filtered with specific column data.So I exported data to a tableview using lookup table but there is an issue while adding filter to it.
For example: Column name is "Milestone Group" and one of its values is Sales duties by which I have to search.
1. How to add Filter = 'Milestone Group' having space?
On adding as shown and providing value = 'Sales Duties'[tableview filter parameter].
I got an error as, "Syntax error: "Missing operand after 'Group' operator."
2. In case column names of sheet have braces, then in such cases how to add column name to filter.For example column names are Product(s), Excl Product(s).