7 Replies Latest reply: Jul 5, 2011 6:02 AM by Nagaian Krishnamoorthy RSS

    Set analysis and value from column

      I have one table:

       

      LOAD * INLINE [

      name,month,value

      paul,one,10

      rom,one,20

      michael,one,30

      paul,two,100

      rom,two,200

      michael,two,300

      ];

       

      I created pivot table:

      name   |   zaz   |   sum({$<month={'one'}>} value)

      -------------------------------------------------------------------------

       

      michael| one     | 10

      paul     | one     |20

      rom      | one     |30

       

       

      I want to modify my formula:

      sum({$<month={$(zaz)}>} value)

      but it is not working.

       

      Correct action of formula:

       

      michael| one     | 10

      paul     | one     |20

      rom      | one     |30

      paul |    two       |100

      rom      |two     |  200

      michael |  two    |  300