I have a crosstab table that displays the 'Total Times Contacted' bands down the side and a 'Do Not Contact' Y/N flag across the top. Within the crosstab is both a count of records within each grouping, along with a percentage of that field to the total (see below). What I want to be able to do is divide, by band, the 'Y' percentage value by the 'N' percentage value, and then take that number x 100 to get the index between the fields. Is this possible?
DNC Flag Y N TOTAL
Time Contacted Total Pct Total Pct TOTAL PCT
1-10 22,418 14.8% 5,690 5.27% 128,808 13.7%
11-20 157,899 19.1% 14,085 13.0% 171,984 18.4%
1-10 | 122418 | 14.8% | 5690 | 5.27% | 128108 | 13.7% |
11-20 | 157899 | 19.1% | 14085 | 13% | 171984 | 18.4% |
21-28 | 121157 | 14.7% | 14623 | 13.5% | 135780 | 14.5% |
29-55 | 278678 | 33.7% | 47289 | 43.8% | 325967 | 34.9% |
56-80 | 120643 | 14.6% | 20823 | 19.3% | 141466 | 15.1% |
81+ | 25058 | 3.03% | 5428 | 5.03% | 30486 | 3.26% |
Total | 825853 | 100% | 107938 | 100% | 933791 | 100% |
21-28 121,157 14.7% 14,623 13.5% 135,780 14.5%
ETC...
........... .............. ............ ............ ............. ................ ..............
TOTAL 825,853 100% 107,938 100% 933,791 100%