Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please see screenshot will show exactly the request bij sample
thanks
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):
actually, you shouldnt. in NUMBER tab, set it as percentage.
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):
Thanks , only added this : *100
=(sum(MutBedragFak)/sum(TOTAL MutBedragFak))*100 works ok
actually, you shouldnt. in NUMBER tab, set it as percentage.
Ok, makes sence , thanks
yw