Hello Guru's
I have score as query subject and i wanted to make different data item out that score query subject.
Query subject score 1-1000
now i want first data item <=300 then second dataitem between 300 and 500, third data item between 500 and 600 , until ireach final maximum score.
so how do i do that? on top of that i have to count individual for respective data item according their score. how can i achieve this with crosstab?
Any help will be deeply appreciated.
Do not worry cognos guru's. I solved the logic myself, i learned a lot about cognos. :(