Pivot Table in OTBI Not Displaying Response Value Data

Summary:

Where I need to transform data from a vertical format to a horizontal format using a pivot table. My original data looks like this:

Buyer Name	Question Name	Supplier	Response Value
John	Q1	ABC Corp	Yes
John	Q2	ABC Corp	No
John	Q1	XYZ Inc	Yes
Mary	Q1	ABC Corp	No
Mary	Q2	ABC Corp	Yes

I want to transform it into this format:

Buyer Name	Question Name	ABC Corp	XYZ Inc
John	Q1	Yes	Yes
John	Q2	No
Mary	Q1	No
Mary	Q2	Yes

Here's what I did:

1. Created a new analysis and selected the relevant Subject Area.