I have a field in my data called P/N. The values in the field for each row of data are either P, N or E. I would like to draw a pie chart but excluding the Es (i.e. it will have two segments, either P or N)
I've started with my Expression as TextCount ([P/N]) but I'm not sure how to go about excluding all the Es.
See the attachment sample file for clearity. On the example i conditionally sum the values with the help of this condition =Sum(If([P/N]='P' or [P/N]='N',Val)) you exclude the value E from the calculation and draw a pie chart.I thin it is clear for you.