4 Replies Latest reply: Jan 8, 2010 12:54 PM by rapozzatir RSS

    Pivot with aggr function

      Hello Everybody,

      I have a Table like the one below:

       

      customercall
      A1
      B1
      C1
      D1
      C1
      D1
      A1
      B1
      C1
      D1


      Of course the pivot table is like this:

       

      CustomerCount of call
      A2
      B2
      C3
      D3


      I would like to have from the first table the following result:

       

      Count of customerCount of call
      22
      23


      Coul you help me?

      Thank you in advance, regards.