-
Calculated measure
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.
-
Hi:
Are the following dimensions, calculated members, or what?
[Insurance_Applied]
[Insurance_Loss]
[Insurance_Paid]
Thanks.
Bill
-
Thanks.
I have resolved it.
-
Mind Sharing How?
Mind sharing how you resolved it - so others can use the forum to further their objectives, like yourself?
Thanks!
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|