How to create a pie chart based on the results of a logical function decision?
For example, suppose you are determining the "High" and "Low" of sales in the following calculated field named Label.
IF SUM([Sales]) >= 10000 THEN "High" ELSE "Low" END
In a cross-tab, it works properly.
However, it does not work when trying to display the number of customers per Label in a pie chart.