1 Reply Latest reply on Sep 13, 2006 10:22 PM by azadisaryev

    Creating a training grid

    lrundquist
      I have a table that houses training information, essentially date, training time, and training event. I am trying to create a cfgrid that will transpose it into a grid with training time as the vertical axis and date as the horizontal axis, with the appropriate training event inside the grid, like this:

      9/15 9/16 9/17 9/18 ...
      0600-1000 Group A Tng X Group A Tng Y Group A Tng Z Group A Final Exam ...
      1000-1400 Group B Tng A Group B Tng B Group B Tng C Group C Tng A ...
      .
      .
      .

      It's essentially a pivot table grouped on training time and date, but I cannot seem to get it to work in CF MX7. Any ideas?

      Thanks for your help!

      Lars