Hi Team,
I'm new to BI Reporting and would greatly appreciate some help on my problem.
am trying to designe a report where am select ref_num, text and response fields.
the outcome of the report should be like below ( want to use cross tab in infoview).
| Question 1 | Question 2 | Question 3 | Question 4 |
In123 | 2 | 6 | 4 | 5 |
In456 | 5 | 5 | 3 | 5 |
but what am getting is like below:
| Question 1 | Question 2 | Question 3 | Question 4 |
In123 | 2 | 2 | 2 | 2 |
In123 | 6 | 6 | 6 | 6 |
In123 | 4 | 4 | 4 | 4 |
In123 | 5 | 5 | 5 | 5 |
In456 | 5 | 5 | 5 | 5 |
In456 | 5 | 5 | 5 | 5 |
In456 | 3 | 3 | 3 | 3 |
In456 | 5 | 5 | 5 | 5 |
is there any tranpose option is available in CABI, so that we can use it to show the data from columns to Rows.?
Thank you,
Regards,
santoshi.P