Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a Pie Chart to show me the count of ID's that exceed limits and then the remainder that are within the limits. Here is the expression to get the Count for the ID's that exceed the limits:
=Count(If([MLimit] > 5000 Or [TLimit] > 2500, [TransID]))
How can I also get the remainder that are within the limits to display on the pie chart?
Hi,
please send sample.
Thanks
André Gomes
May be this as your second expression:
=Count(If([MLimit] <= 5000 and [TLimit] <= 2500, [TransID]))
Here is a sample.
This?
Here I have added two approaches you can use to reach your final goal
Hi Cliff,
I have used two expression.
first expression is used to select all satisfied criteria and second is used to select the opposite of the first thats means you will get all values in our pie chart.
Thanks,
YJ