Calculated measure

[olutimi]

Please help.
I created a calculate measure using three attributes. When i view calculated measure in Excel 2007 it displayed the correct values using the constituents of the measure.

For example.
Calculated Measure Total_Insurance_Outstanding

is the sum of
SUM({[Insurance_Applied], [Insurance_Loss], [Insurance_Paid]}, [Measures.TransAmount])

In excel 2007 Total_Insurance_Outstanding is correctly displayed as Measure.
However when the calcualted measure was dropped into the data pane it displayed as follows

Total_Insurance_Outstanding
Insurance_Applied, Insurance_Loss, Insurance_Paid

Rather than what i expected
Total_Insurace_Outstanding


Please advice.

[Island1]

Hi:

Are the following dimensions, calculated members, or what?

[Insurance_Applied]
[Insurance_Loss]
[Insurance_Paid]

Thanks.

Bill

[olutimi]

Thanks.

I have resolved it.

[Island1]

Mind sharing how you resolved it - so others can use the forum to further their objectives, like yourself?

Thanks!

Bill