2 Replies Latest reply: Apr 17, 2012 10:52 AM by Celambarasan Adhimulam RSS

    Count When (condition)

      Hi,

       

      I have a problem in implementing the count function.

       

      I am trying to insert an expression in a pivot table. The expression should return the count of glucose values for the glucose values which are less than 100.

       

      I tried using: Count({$<Glucose={'<= 100)'}>}[Glucose])

       

      Could someone help me out? Thanks in advance!