8 Replies Latest reply: Jun 18, 2014 11:43 AM by Richard Garforth RSS

    Use set analysis without calculation

    Matt Maino

      Hi everyone,

       

      I am interested in using set analysis to simply narrow down my dimension in a straight table.

       

      I would like to only show the [Account Number]s in my data where Field1 = 1 and Field2 = 'A'. Shown below is what I have so far, but I'm unsure if set analysis is capable of this.

       

      ({1<Field1={1}, Field2={'A'}>}[Account Number])

       

      Does anybody know the best way to do this? Thanks.