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
As a side note, I am trying to do this without having to create Variables.
Use the below formulae in each column
=If([ Caption ]="Tickets";"Yes";"No")
=If([ Caption ]="Refereed";"Yes";"No")
=If([ Caption ]="Bike";"Yes";"No")
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