Multiple If's

[unknownb]

Hi Gang, 

I'm wondering if you can help. We have a number of clients that have answered a series of questions, we need to create a pivot which shows those who have answered 'Yes' to A and have also answered 'Approve' to B.

Basically... 
IF(Q= '1' and A = 'Yes') and if(Q = '2' and  B= 'Approve'), answer)

Is this possible?

i've created a pivot which shows either but not both. 

[Dalton_Ruer]

Can you show example of your table data? My guess is that you have each question and answer response on a different row. 

[martinpohl]

I think it would help if you post your data model and the final result.

Why do you want to use a pivot table? what are the dimensions should be?

Regards