Column Results into Rows

building reports
1

Hi,

This is really easy I know but I’ve created 3 variables in BO to pull different element values.

The trouble is it’s creating 3 separate rows whereas I just need the one

For Example this is hows its looking

Person Element 1 Element 2 Element 3
A Smith 10
15
20

However I just want all the values in the one row.

Thanks

2

Hi Brad,

Check this out

Thanks,
Mohammed

3

Perfect thank you @Mohammed

4

Hi Brad,

You’re welcome! FYI, there is a way to do this at the report level as well (checkout this blog), but from personal experience, I’ve seen that this report level logic fails when we’ve a lot of data, and I’ve done it at the Universe all the time.

Thanks,
Mohammed

1 Like