3 Replies Latest reply: Jul 25, 2011 9:56 AM by Stefan Wühl RSS

    help with exp. calculation

      Hi,

       

      i have the following data:

       

      date| type | v_1| v_2| v_3| v_4|

      2011-07-11|0|258 |18 |149 |4344 |0 |

      2011-07-11|14|1264 |411 |620 |2492 |0 |

      2011-07-11|28|1974 |677 |934 |5564 |0 |

      20011-07-11|56|1083 |642 |660 |2037 |409 |

       

      2011-07-25|0|276 |26 |166 |5149 |0 |

      2011-07-25|14|1037 |239 |537 |2946 |0 |

      2011-07-25|28|1403 |510 |635 |2237 |0 |

      2011-07-25|56|2520 |1369 |1292 |3483 |868 |

       

      type 0 on the 11th is type 14 on the 25

       

      how can i display them as a sequence?

       

      something like this..

       

      v_1_type0(2011-07-11) | v_1_type14(2011-07-25)

       

      in the first column i will have the information from the 11th type 0 v_1

      in the second column i will have the information from the 25 type 14 v_1

       

      and so on...

       

       

      I hope i made myself clear.

       

       

      Thanks in advance.