If the league can handle another, count me in.

it has been a while since i have fired up AdventureWorks, but

select

[Customer].[Customer].Children on 0

from [Adventure Works]

will return the customer name for all customers in this rather flat hierachy, exluding...

Yes, I think I may have answered an outdated version of the question. Is the problem then:

count of all customers to which a sale has been made, by age?

shouldn't SET FilteredSet AS count in the second line, be just a tuple to define the set? That is: Set FilteredSet as (Dimensions that define the set)

In other...

As a general form for Percent of Set queries, you could use a calculated measure with this syntax

with member [measures].[percent_rank] as ([Measures].[Impressions],[aDimension].[aHierarchy].CurrentMember) / ([Measures].[Impressions],[aDimension].[aHierarchy].CurrentMember.Parent)

The first term gets you the portion...

If you already have a count measure, usually defined by the cube design wizard in the form "<<MeasureGroupName>> Count",

then

select [Measures].[MeasureGroupName Count] on 0,

FILTER([dimCustomer].[Age].Children, [Measures].[Sales]<>0) on 1

from <<YourCubeNameHere>>

Will yield the count...