7 Replies Latest reply: Jul 9, 2015 7:28 AM by Gysbert Wassenaar RSS

    How to count value that is in a PIVOT table

    Jim Chan

      Hi there,

       

      I need to create a bar chart that display active members only. i have created a pivot table to simulate the situation. For instance Active member has a count(code) 2 times or more. non active is just 1.

       

      in my bar chart, i added week as my dimension, and measure by count(code). problem starts when i wanted to be more specific that, the count(code) should only display 2 only or more. but i couldnt get it right. i tried to apply this code

       

       

      if(count(code) >= 2, count(code)  - is not working.

      countcode.jpg

       

      Rgds,

      Jim