7 Replies Latest reply: Jun 17, 2011 7:17 AM by dannygerst RSS

    Dynamic columns/header based on table entries

      Hi,

       

      I like to make a diagram dynamic based on values in a table. It is like a Pivot, but this does not matches to my requirement. Here an simple example of what I like to archive.

       

      Table

                                                              

      Item_ID | Item_type | Item_Value| Time

      item 1   |  C2H6      |   23.45       | 01.01.2011

      item 1   |  C2H6      |   24.67       | 01.02.2011

      item 1   |  C2H6      |   31.25       | 01.03.2011

      item 1   |  C6+        |     0.34       | 01.01.2011

      item 1   |  C6+        |     0.47       | 01.02.2011

      item 1   |  C6+        |     0,51       | 01.03.2011

      item 1   |   N2         |    10.32      | 01.01.2011

      .....

      item 2   | C2H6       |   24.78       | 01.01.2011

      ......

       

      Result should be:

       

      Time          | Item_ID | C2H6 | C6+ | N2 ...

      01.01.2011 | item 1   | 23.45 | 0.34 | 10.32

      01.01.2011 | item 2   | 24.78 | ......

      01.02.2011 | item 1   | 24.67 | 0.47 | ...

      01.03.2011 | item 1   | 31.25 | 0.51 | ....

       

      The Item_types are limited but not always predictable. So the column should be generated automaticlly. My idea was to get all item_type distinct. Making these values the headline. After this I need to put the number values of the item_type in that column.

       

      Can anyone give me a glue or a solution?

       

       

      Thanks in advance,

       

      Danny Gerst