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:




      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?