What security filter will assign security to hierarchy, filtering the members displayed to end users?
You need to create a % of total (by region) calculation by customer in you aggregate storage database for Net_Revenue