Pie Chart

[#1]

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

[Anonymous]

You should be able to modify this expression to your needs, by changing FieldOne to your Dimension and FieldThree to your Fact :

    Sum(Aggr(If(Sum(FieldOne)>0,Sum(FieldOne)),FieldThree))

[Anonymous]

You certainly can, as bill.markham pointed out.  The question is - maybe pie chart is not the right choice.  I recommend bar chart.

[#4]

Thanks for the reply ... but I did not understand ... you please be a little more specific?

Thanks

Gian Paolo

[Anonymous]

For your Pie Chart could you paste the Dimension and Expression in here and I'll slot them into my expression for you.

[#6]

Hi Michael

the general management  wants pie .....

Thanks

Gian Paolo

[#7]

Hi Bill

I can send you the application masked?

Please?

Thanks

G P

[Anonymous]

Ask them how a negative slice of pizza should look like .  You can either not show them as Bill suggests, or show as positive - in both cases it distorts information.

Pies are overrated

[Anonymous]

That will do nicely.

[pokassov]

Hi, Gian!

You can change your expression by this way:

nummax(0,sum(FV_Imponibile))

In this case your negative values will be omited