Please see attached "TEST TWBX".
It consists of a pie chart and a crosstab. I'm trying to get the count to be the same for both the pie chart and the crosstab. I have a set of filters that contain conditions in which both the pie chart and crosstab should fit.
I'm looking for:
1) Percent Spent of "Greater Than or Equal to 95%"
2) Spent as "Yes"
3) Balance of "$0.00"
As I have it right now, you will see that the total count for the pie chart is 6 while the total count for the crosstab is 3.
What do I need to do in order to get the same total count for both the pie chart and crosstab?
Thanks in advance!
@Matt Lutton Per the required conditions on the filters, it looks like the crosstab is correct. It should only have 3 lines. It is the pie chart that is not correct. It should show a total count of 3 rather than 6.
How can I get the pie chart to show a total count of 3 to match the crosstab?
