I found a solution on SQLDev - [Not exactly what I was looking for but similar]

http://www.sqldev.org/sql-server-analysis-services/aggregate-function-none-11910.shtml

--------------------------------------------------------------------

Hi Sandrine,

I think you need to set the IsAggretable property for the parent-child hierarchy, not...

Steve,

Thanks for your reply. No aggregated value but actual value of [PercentageAchieved].

a matrix like....

-------| 2008 | 2009 | 2010

-----------------------------

John | ...

Cheers mate!

it's very close to what I was looking for!

Thanks for you response but it doesnt solve the problem.

SourceTable could have rows like:

ID SourceAmout

1 1300

2 2000

3 ...