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