I have two filter pane chart, ones' field is '[Company Name]' and anothers' field is '=if(isNull([Interests]), null,[Company Name])'(filter pane for the companies that has a value in 'Interests' column). They are basically the same, Company Name, but have different Field expression and I want them to selected as a same field name(Company Name).
the filter pane chart which has a field '[Company Name]' definitely selected as a field name 'Company Name',
but filter pane chart which has a field '=if(isNull([Interests]), null,[Company Name])' is selected as a field name '=if(isNull([Interests]), null,[Company Name])'.
Can I make them selected under the same selection field name???