Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
pie chart.... between the values that I represent, there are positive and negative values then the graph does not appear for the presence of negative values.
If I have many clients I bypassed the problem by showing the first 15 customers and the rest as other ... at this point the negative value is absorbed and the graph appears.
The problem is when I have a number of customers poor and I can not handle a customer as part of Other.
Can I exclude from the pie chart, the negative value ... if you possible ... how?
Thanks to all in advance.
Gian Paolo
Sum(Aggr(If(Sum(FV_Imponibile)>0,Sum(FV_Imponibile)), $(=GetCurrentField( _Cliente)) ))
Although the suggestion from pokassov looks more elegant.
Do take note of the comments by msolomovthat a Bar Chart could be better than a Pie Chart. There is a great book by Stephen Few called Information Dashboard Design which explains pro's & con's of various visualizations that I would highly recommend.