Skip to Content
avatar image
Jeff Crisp

Creating a Webi Report Question

Oct 24, 2016 at 06:39 PM | 32 Views

I have the following fields on a report:

Institution
Personal_ID
Caption
Caption_Value

My report looks like the following:

Institution Personal_ID Caption Caption_Value
1 1 Tickets Yes
1 1 Refereed Yes
1 1 Bike No
1 2 Tickets Yes
1 2 Refereed Yes
1 2 Bike Yes

Is it possible to create a report that looks like the following:

Institution Personal_ID Tickets Refereed Bike
1 1 Yes Yes No
1 2 Yes Yes Yes

SAP Knowledge Acceleration, version for SAP BusinessObjects Web Intelligence
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Jeff Crisp
    Oct 24, 2016 at 06:58 PM

    As a side note, I am trying to do this without having to create Variables.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 23, 2016 at 03:23 PM

    Use the below formulae in each column

    =If([ Caption ]="Tickets";"Yes";"No")

    =If([ Caption ]="Refereed";"Yes";"No")

    =If([ Caption ]="Bike";"Yes";"No")

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Sai P
    Nov 28, 2016 at 09:38 PM

    Hi Jeff,

    Did you try to create something like in below link formula?

    http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html

    Thanks,

    Durga

    Add comment
    10|10000 characters needed characters exceeded