I have a bar chart that has a Dimension of Brochures.Class. The data contains either Class III, Class II, Class I and OTC Drug.
Currently the chart lists each Dimension and sums the number of Total to Review and Total Completed in a stacked bar chart.
How can I combine the Class III and Class II bars into a single bar summing up both (Call it Class II/III). And do the same for Class I and OTC Drug (Call it Class I/Other). So I basically end up with a two-bar chart showing the sum of two expressions.
Please note that if you have to compare without wildcards, using match() is a better choice in terms of performance. And also, be careful of the fact that wildmatch() is case insensitive whereas match() is case sensitive.