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.
Hope this helps you.
Exclude_test.qvw 120.5 K
Hi, thanks for your work Anand, but though it worked in your file, I couldn't recreate it in my original one (said that Val was an error). Sunil, yours worked fine apart from there is a superflous )
It should be TextCount (if([P/N] <>'E',[P/N]) )
From another source, I've got this code too, I'm not sure how it works but it does