03-03-2017 02:51 PM
I am trying to display percentages by year in a multi-dimensional table. Everytime I try to use the pctn I get the percent for the entire column, but I would like to get the percent Yes/No by year. Here is what I would like to see:
2012 2013 2014
Co-morbidity Co-morbidity Co-morbidity
No % Yes % No % Yes % No % Yes %
Condition: 900 90 100 10 550 68.8 250 31.3
The way I have it now it is calculating the percent for the entire row for all years.
03-03-2017 03:03 PM
Without seeing the data, it's difficult to help, but if rowpct or colpct won't do what you want, this is likely a case where you're going to have to use a custom denominator for calculating percentages.
Need further help from the community? Please ask a new question.