CR 9
I have to create a cross tab (manual Cross tab not an option because the columns are dynamic)
column Survey questions 1 2 3
row
Sales person % of yes for each question
Returned to me is the Count of yes, count of yes and no, count of no... problem , I can create a formula (yes/total yes/no) to give me the percentage but the cross tab wants to do a summary function on the value which is giving erroneous values. Is there anyway around this?
Terri
I have to create a cross tab (manual Cross tab not an option because the columns are dynamic)
column Survey questions 1 2 3
row
Sales person % of yes for each question
Returned to me is the Count of yes, count of yes and no, count of no... problem , I can create a formula (yes/total yes/no) to give me the percentage but the cross tab wants to do a summary function on the value which is giving erroneous values. Is there anyway around this?
Terri