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.