Counting the "Yes/No" values across multiple fields for a given record.

[#1]

I wasn't sure how to word my question or what keywords to search for, so I apologize in advance as I know this has already been asked before.

I have data in which 10-12 fields are just "Yes" or "No".

For each record in my data, I want to determine the percentage of Yes/Nos.

My dimension is a list of Programs, which are the records in question.

Any help? Thanks guys.

[#2]

could you please post your sample data?

Regards

Ankur

[#3]

I added a sample data file.

It is fairly straight-forward, I just can't think about it correctly.

So I need to show that for the first record there, 66% is 'Yes'.

[Gysbert_Wassenaar]

See attached qvw.

[#5]

Your second chart is what I want. I'm not very good at crosstables but I'll try to work backwards through what you've done.

Thanks!