Hi - I need help with the command to convert this table from counts to percents of the total. Is there an easy trick to this?
You've not really provided enough information for someone to help.
Please see our etiquette post at http://www.cognoise.com/index.php/topic,24030.0.html (http://www.cognoise.com/index.php/topic,24030.0.html) and repost with more information.
Most likely, you will need to change the expression currently showing you the counts.
'Percent of' calculations require you to learn the 'FOR' argument that works with all aggregate functions. Here is a good paper on it:
ftp://public.dhe.ibm.com/software/dw/dm/cognos/reporting/advanced_report_design/using_the_at_and_for_options_with_relational_summary_functions.pdf