Turn Column Names into Row so it can be used as list box !

[#1]

Hi Guys,

I have attached a sample QVW & QVD with a very basic exmaple.

I want to turn column names into rows so I can have them as dimension

Raw table looks like this.

I want to create a table like below

So Every time I select a different student name then the score should change accordingly and if Socre is < 50 then its fail and colour should change accordingly too.

I also want to have a list field of subjects so i select one of the subject as a filter.

Is it possible in to turn column into row to use as filter?

[avinashelite]

Use Cross table and resident load ...create a new table , check the below thread to get more infor about the crosstable

The Crosstable Load

[migueldelval]

Hi Lokesh,

Avinash has reason, it´s the best way to make.

But you can see in attached file other way to make it.

Regards

Miguel del Valle