Yeah, my question may not be clear.
But I found the solution:
Just create a member for this two types.
member [Dim_MeasureType].[Hierarchy-Measure-Type].[TotalCO2] as
'sum(
(union([Dim_MeasureType].[Hierarchy-Measure-Type].[MeasureType].&[6],
[Dim_MeasureType].[Hierarchy-Measure-Type].[MeasureType].&[7])
,[Measures].[MeasureValue])
)'
[quoted text, click to view] "Darren Gosbell" wrote:
> I am not entirely sure I understand your question, but could you create
> a parent child or a two level ragged dimension that would look as
> follows
>
> type 1
> type 2
> type 6
> - type 3
> - type 4
> type 5
>
> As you can see, I have set up type 3 & 4 as children of "type 6", by
> default this would give type 6 the value of the sum of types 3 & 4.
>
>
> --
> Regards
> Darren Gosbell [MCSD]
> <dgosbell_at_yahoo_dot_com>
> Blog:
http://www.geekswithblogs.net/darrengosbell >
> In article <6D63CF56-F740-4BEC-89DE-AA9DE438A8D2@microsoft.com>,
> Word2003memoryLeakage@discussions.microsoft.com says...
> > I have a measure type dimension with 1 - 5 types.
> >
> > I want to calculate sum of measures with type of 3 and 4. So I will have 6
> > types. And I want to show sum of measures on column, and 6 types on rows.
> >
> > how can do this?
> >
> > Thanks,
> >
> > Guangming
> >
>