Set Analysis to ignore a chart dimension?

Tue, 29 Oct 2013 14:05:21 GMT

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?

Re: Set Analysis to ignore a chart dimension?

swuehl — Tue, 29 Oct 2013 14:08:46 GMT

=Count(TOTAL<DimensionA> distinct AccountNumber)

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

Tue, 29 Oct 2013 14:18:47 GMT

Thank you very much for your swift and accurate response!