formula problem in graph

[#1]

hi

i have a pie chart that is splitted up in ariclegroups and shows the income. the formula is sum(income).

I want that the pie chart shows the percantage of sales per articlegroup. basically i have to get a formula that divides the partial income per articlegroup by the total income, right? but i can't figure out the correct formula for that. please help me.

[tresesco · Accepted solution]

Try like:

=sum(income)/Sum( Total income)

And  in the number tab check 'Show in Percent (%)'

[sudeepkm]

can you please post your sample qvw?

have you tried using Relative option in the chart expression tab?

[#4]

Try tresesco's formular and put the articlegroup as dimension. Don't forget to check the relative-box in your pie-chart.

That should do the trick....

[#5]

thanks for your help. i didn't know the 'total' command. this was very easy