OpenText technical experts collaborate with supported customers and partners in the Magellan product area.
Breaking row by value and column
I have two requirement that I am trying to figer out what would be the best way to do in BIRT
1. I have two column Order and Level
this two column has two rows but I want to break the rows based on values.
I have attached two images, image1 is what I have and image two in what I want to have my output be like.
2. I have two column Order and Level
and I want to break the Level value into separate columns,
Image 1 is what data looks like and image3 what I want to out put to look like.
I could have done that by creating computed columns but it wont be dynamic.
Appreciate any help, sample and advice