7 Replies Latest reply: Sep 17, 2012 10:36 AM by Mayil Vahanan Ramasamy RSS

    Set Analysis

      Greetings All,

       

      Can you please advise how can I write this  below query in Set analysis in a pivot table:

       

      IF( count(bat_no) > 1, SUM(new), SUM(old))

       

      Many Thanks!