Thanks. It worked. Then I noticed one thing. It filtered out the null values. But the % value didn't re-calculate. Is there a way to show the re-calculated %?
See the following screenshots. When I use Doesnot contain Unspecified, then it filtered out the unspecified from the chart, but still showed in the table.
So you will need to use workspace, add a segment to filter it out. Right now, my users are using the regular report. Is there a way to filter it out?Thanks