6 Replies Latest reply: Dec 4, 2012 11:33 AM by Jaime Marines RSS

    Count expression for diff fields...

    Jaime Marines
       
       Hello QVComm....
       

       

      I am using below expression :

       

      COUNT({<ESNOMATCH={'-1'},ESNOMATCH1={'-1'},ESNOMATCH2={'-1'}>} ESremision)

       

       

      Using Expr in Pivot Table, How can I Count ESremision (9) with these conditions.........Tk in advanced.

       

      ESremisionESNOMATCHESNOMATCH1ESNOMATCH2
      37
      76-1
      77-1-1
      155-1-1
      167-1-1
      174-1-1-1
      228-1-1-1
      321-1 -1
      387-1 -1
      Count = 9

       

      JMC