2 Replies Latest reply: Oct 29, 2013 10:18 AM by Rob Ritchie RSS

    Set Analysis to ignore a chart dimension?

      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?