Dear All,
I would like to figure a way in SQL 2005 Analysis when a specific attribute is picked from a dimension, only a specific member should be displayed as a Grand Total value.
In the example below " Family of Benefit" is my dimension, and the attribute is called "Family of Benefit Name". The member 'In Patient' should be displayed as a Grand Total value instead of aggregating all members.
Grid Example:
MemberName Measure Value
In Patient2,500
Out Patient2,450
Dental 300
Phsycho 500
Grand Total5,750INCORRECT
Grand Total2,500To Achieve
Kindly help on this topic
Regards
Demi