showing percentage in a chart

[JACKNIEKERK]

please see screenshot will show exactly the request bij sample

thanks

[edwin · Accepted solution]

try the expression 

=sum(MutbeDragFab)/sum(TOTAL MutbeDragFab)

this gives you the percentage for each
then in dimension limits set top 10.

in my example, the first chart shows the percentage for all (totals 100%), i set to top 5 dimension limits  in second chart (you can turn Others off/on):

[JACKNIEKERK]

Thanks , only added this : *100

=(sum(MutBedragFak)/sum(TOTAL MutBedragFak))*100    works ok

[edwin · Accepted solution]

actually, you shouldnt.  in NUMBER tab, set it as percentage.

[JACKNIEKERK]

Ok, makes sence , thanks

[edwin]

yw