Hello experts
How can i arrange list columns in a single row with multiple rows data spreading bottom to top (left to right in upward direction)?
what i have right now is like this
col1 col2 col3 col4 col 5 col6
Row 1 D6
Row 2 D5
Row 3 D4
Row 4 D3
Row 5 D2
Row 6 D1
AND I want only onw row with D1 D2 D3 D4 D5 D6 displayed.
Any expert help will be hugely appreciated.
I can not use Group span since D1 can have D1A AND D1B data. I have a 6 data items with case statement like this
case condition
when '1' then data item
end
which produces the result as i have mentioned above.
Make sure that the query is defaulted to auto group and summarize. Also, sometimes I have needed to go into the Framework Manager model and create a determinant on the query subject in order to get things to display on one row. Is that possible in this case?