Set Analysis to ignore a chart dimension?

[#1]

Hello all,

I want to answer the question: "What percentage of Accounts with DimensionA also had DimensionB?"

I'm trying to create a table chart that looks like this:

DimensionA

DimensionB

Expression1 = Count(Distinct ACCOUNTNUMBER)

Expression2 = [count distinct accountnumber for data that matches DimensionA but ignores DimensionB]

Expression3 = Expression2 / Expression1.

As you can see, I'm stuck on Expression2.

I know that I can use Set Expressions to ignore SELECTIONS like so:

=Count(distinct {$<DimensionB=>}AccountNumber)

...but this doesn't carry over to chart dimensions. Any suggestions on how to model a set expression (or something else) to get what I want?

[swuehl · Accepted solution]

=Count(TOTAL<DimensionA> distinct AccountNumber)

Use the TOTAL qualifier instead set analysis to ignore a dimension.

[#3]

Thank you very much for your swift and accurate response!