5 Replies Latest reply: Jul 1, 2011 4:17 AM by Miguel Angel Baeyens de Arce RSS

    Condition sum

      Hi all,

       

      any one can help me out of this question:

       

      Say I have a table like this:

      LOAD * INLINE[Tab,Name,Num

      Tab1,A,1

      Tab1,B,2

      Tab2,A,3

      Tab2,C,4];

       

      I need a pivot table like this:

      dimension Name

      expression:

      if Name in Tab1 and not in Tab2 , calculate sum

       

      so the pivot table is :

       

      Name Num

      A 0

      B 2

      C 0

       

      Thanks in advance

       

      Dihui

        • Condition sum

          The obvious answer is to try using set expressions i.e. sum({$<Tab={Tab1}>}Num). But maybe your example data is oversimplifying this. The set expression will just given sum where Tab in in the set of values {Tab1}. Your sampel results don't seem to match the expression you have given as the sum for A would be 1?