indirect set analysis

[m4u]

Dear all,

I have a table of sales per sales person, for example:

SalesPerson,Sales

A,1000

A,2000

B,-5000

B,-400

G,1000

Now, i want to use a pie to show sales per sale person, but my problem is that because the total sales of sales person "b" is less then negative so the pie could not work. how can i exclude the sales person that the total sales (according to selection) is less the zero ?

Meany thanks

[luciancotea]

1. Don't use pie in this case, it's misleading. Use bar chart.

2. If you still want to use pie: =if( sum(Sales) > 0, sum(Sales))

[Oleg_Troyansky]

... or, as an alternative:

rangemax(0, sum(Sales))