2 Replies Latest reply: Mar 5, 2013 5:06 AM by Aio Aio RSS

    Pivot table on disjoined field

    Aio Aio

      Hi everybody,

       

      I got two tables:

       

      Table1:

      Whowherecount
      Apl_14
      Apl_13
      Apl_28
      Bpl_15

       

      Table2:

      whowherefrequency
      Apl_110
      Apl_35
      Bpl_120

       

       

      the results should be a pivot table with:

      whowheresum(count)?Function?(FREQUENCY)other expressions based on A
      Apl_1710
      Apl_280
      Apl_305
      total A 1515
      Bpl_1520
      total B 520

       

      If I use a left join between the table A and table B, my frequency will be wrongly a sum (ex a;Pl_1;20 instead of 10, caz in order to have the total frequency, I should use SUM(b.frequency)).

      In both cases (left join and join) I got no A;Pl3.

       

      I cannot understand:

           1) what should be the ?function? used for the frequency (Expressions)

           2)How could I join the two table to have the A;Pl_3 in the pivot (Scripting)

       

      Saying "other expressions based on A" I 'd like you to understand the other expressions of the pivot table are quite complex and referring only to table A.

       

      Can you help me?