Hi Iain,

Try this sort of thing - In my example I have created a memeber that would be your calulation (in this case % European clients) and then unioned that to the list of clients

with

member [Client].[Client Region].[% split] as

([Client].[Client Region].[Europe]/[Client].[Client Region].[All])

SELECT UNION({ [Client].[Client Region].[All].CHILDREN } ,{[Client].[Client Region].[% split]}) ON COLUMNS ,

NON EMPTY { [Product].[Product Level 1].[All].CHILDREN }

* { [Product].[Product Level 2].[All].CHILDREN }

ON ROWS

FROM [OLAP]

WHERE ( [Measures].[Revenue] )

It may not be 100% what you are after - but I can help if it isn't

Mack