Skip to Content
Former Member
Nov 29, 2005 at 08:37 AM

Percent of business partner


Hi All

I want to add a condition to my query that return a certain number of business partners (based on percentage). If I use the Top % i condition I can only reference my key figures and not the characteristic 0bpartner.

Ex: Give me 70 % of my best business partners based on revenue. If i have 1 million business partners i would like to receive 700 000 in my query.

Any suggestions?