Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
could you please post your sample data?
Regards
Ankur
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'.
See attached qvw.
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!