5 Replies Latest reply: May 9, 2014 4:30 AM by Lorenzo Topi RSS

    count with a condition

      Hello,

      in the "expression" tab of a pivot table, I'd like to make a count only if a condition is true, like this:

       

      CONDITION: [QUOTA PARTECIPAZIONE DIRETTA]>'0,0' and [QUOTA PARTECIPAZIONE DIRETTA]<='0,1'

       

      EXPRESSION: count(DISTINCT [CODICE ISTAT ENTE PARTECIPANTE])

       

       

      Where I go wrong?

      Thanks.

      Lorenzo