Calculating % of a specific crosstab response

[Slow1911s]

Here's my crosstab report

Answer Name1 Name2 Name3

Yes 90 95 85

No 10 10 35

Total 100 105 120


I need to devide the number of Yes responses for Name1 by the total number of responses. I tried doing it like this =(([Name1]=Yes)/sum([Name1])), but that isn't working.

Thanks in advance,

Dave

 

[Dennisk]

What I would do is use the XTab in another query and add the values in the columns if and only if the number of columns are constant.

 

[suvarna]

May I know if the following solution helps you

Include more columns in your cross-tab query for %yes and %no for each of the names