Layout

[BiliBoy]

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.

[BiliBoy]

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.

[bi4u2]

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?