Aggregate when measure contains a specific value

I have the following:

A hierarchy named [Tire].[Tire Hierarchy] that contains a list of tires by
tire manufacturer.

I have two measures in the fact table:
[Measures].[NRT Units]
[Measures].[Times Retreaded]

I need to create a sum of [NRT Units] for all tires at any level when the
[Times Retreaded] = 1. Anyone have any suggestions?

Would it be viable to create dimension on times retreaded? You can filter by
measure but it will be easier to do i you create a dim and then filter by
it. Not to mention what does it mean = 1? Does it aggregate on diff levles?


MC


"Owen J." wrote in message

>I have the following:
>
> A hierarchy named [Tire].[Tire Hierarchy] that contains a list of tires by
> tire manufacturer.
>
> I have two measures in the fact table:
> [Measures].[NRT Units]
> [Measures].[Times Retreaded]
>
> I need to create a sum of [NRT Units] for all tires at any level when the
> [Times Retreaded] = 1. Anyone have any suggestions?