Are you the business user?  if so, then the system has no value without your input! 

it's a best/leading practice I'm giving you here ... have it built once so it can be reused.  built by a developer who should understand the technical implementation of the level-based measure.

else, study up on using the AGGREGATE(x AT y) function ... and have to repeat it every time you want to use it.

I'll see if I can put it together on the sample app and show you a screenshot ...

the online sample app wasn't up earlier...

this blog post is built on the same RPD... http://obieehelper.blogspot.com/2012/04/aggregate-at.html

Learn Oracle and OBIEE: Aggregate at

essentially:

Total Measure = AGGREGATE (Measure AT a dimensional hierarchy level)

% of Total = Measure / Total Measure

IE:

Assume hierarchy Region.Office.SalesPerson

Filter on SalesPerson = 'Sam'

Total Office Sales = AGGREGATE (Sales AT Region.Office) = 1000

Measure = Sales = 51

Salesperson % of Total Sales = 100*(Sales / Total Office Sales) = 100*(51 / 1000) = 5.1 

Filter on SalesPerson = 'Jane'

Total Office Sales = AGGREGATE (Sales AT Region.Office) = 1000

Measure = Sales = 75

Salesperson % of Total Sales = 100*(Sales / Total Office Sales) = 100*(75 / 1000) = 7.5 

NOTE:  Total Office Sales doesn't change - it is level-based on ALL OFFICES --- IF Sam and Jane are in DIFFERENT OFFICES - then it would reflect the office they are in (query grain)