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?
Time Contacted Y Total N Pct N Total N Pct TOTAL PCT
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% |