Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you show example of your table data? My guess is that you have each question and answer response on a different row.
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