I am new to MDX statements and am at a loss as to how to formulate a percent of totals as follows. I'm basically wanting a percentage based on a column/row intersection:
Measures
Hours
Cost
LBR Employee Org
Company
Division
Labor Category
Employee
Rate Pool
Rate Pool
I would be displaying the LBR Employee Org in rows and Rate Pool in columns. I would like the contribution (as a percent) of an employee for the Company / Rate Pool. In other words, suppose an employee's contribution was .10 of the total hours for the company and .05 percent for the rate pool. I would like that row/column intersection to show .10 * .05 or .005 so the intersection of totals of Rate Pool and LBR Employee Org will be 1 or 100%. Currently, I have four rate pools, so I end up with 400%.
Sorry if I'm not clear enough or not providing enough information. I will be happy to respond with more information.
Measures
Hours
Cost
LBR Employee Org
Company
Division
Labor Category
Employee
Rate Pool
Rate Pool
I would be displaying the LBR Employee Org in rows and Rate Pool in columns. I would like the contribution (as a percent) of an employee for the Company / Rate Pool. In other words, suppose an employee's contribution was .10 of the total hours for the company and .05 percent for the rate pool. I would like that row/column intersection to show .10 * .05 or .005 so the intersection of totals of Rate Pool and LBR Employee Org will be 1 or 100%. Currently, I have four rate pools, so I end up with 400%.
Sorry if I'm not clear enough or not providing enough information. I will be happy to respond with more information.