3 Replies Latest reply: Jul 4, 2011 4:11 AM by Floda Adolf RSS

    Ignoring second dimension

      Hello. Sorry, my english is bad, but I hope I would be understood.

      I have one table:


      LOAD * INLINE [

      a,b,c,d

      adam,one,43,one

      adam,two,655,one

      adam,three,56,two

      mor,one,6,one

      mor,two,323,two

      mor,three,543,two

      ];

       

      I want to create pivot table like this:

      a,b,sum(c) for a dimension ignoring b

      adam,one,754

      adam,two,754

      adam,three,754

      mor,one,872

      mor,two,872

      mor,three,872

       

      I can't write function for this table.