How to create pie chart with two expressions

[Anonymous]

Hi,

I would like to create a pie chart which will give me the ratio of two sums:

sum(xxx) (answer of sum is 8.000.000.

sum(xxx) (answer of sum is 2.000.000.

So I expect a pie chart which will give me a piece of 80% and a piece of 20%.

Now I get two times a piece of 100% when I choose relative and have set two expressions which I have devided by the total of sums (10.000.000).

I hope anybody can help me.

Gr. Pascal

[krishnacbe · Accepted solution]

Hi,

Hope the attached file will help you.

[Anonymous]

Hi  Krishnapriya Arumugam,

Thanks for the solution.

Last but not least, I get a result of 88% against 14%. (above 100%) (??)

I expect the following ratio (my previous message was fictional): 

86,4734%

13,52,66%

Do you know how that's possible?

Thanks in advance!

Gr. Pascal

[krishnacbe]

Hi,

Can you share some sample data and expression you have used.

[Anonymous]

Try this way.

[Dan36]

Can someone pls share the answer not in .qvw