Sum of column instead of row

[Pavel1234]

Hi,
I have got problem described on following picture:

In table A there is SUM of Inventory Value = 1083. I spent a lot of time to get this SUM into every row in table B but with no result :-( Anyone help me ??? Its urgent!!

Thx

 

[MDXer]

You need to create a Calculated measure with the calculation as NULL.

Then using a Scope statement with the scope being the measure you can write the calculation to be the some of your inventory.

SUM([InventoryDim].[Inventory].[ALL], [Measures].[Inventory Value])


if done right the scope will force this value where ever it is placed.