Show percentages based to Total Cases Responding in Categorical AnalysisHello, in the table below, I'd like to show the percentages based to Total Cases Responding, rather than the ones based to Total Responses or Total Cases, so the Walmart Supercenter percentage would be 88.33%. I can't find any way to do this. Thanks.
Re: Show percentages based to Total Cases Responding in Categorical AnalysisJust wanted to get back to you and say this worked like a charm! Thanks very much!
Re: Show percentages based to Total Cases Responding in Categorical AnalysisThat should do the trick as I was using version 13.1 to confirm my thoughts. Upgrading is always a good thing! 
Re: Show percentages based to Total Cases Responding in Categorical AnalysisThank you - I don't have that option. I have version 12.2. I've asked my SysAdmin for an upgrade to 13.1. Hopefully it will do the trick.
Re: Show percentages based to Total Cases Responding in Categorical AnalysisGo to the red popup menu by the Categorical title and choose Rate Per Case Responding. I think that will give you what you want.
Re: Show percentages based to Total Cases Responding in Categorical AnalysisThanks, Uday, I should have been more specific. I'm not using the Tabulate function to create this table, since it's a multiple response question I'm analyzing (QPROFILE_58). It's under the Consumer Analysis tab (under Analyze) and I'm using the options below to create the table:
Re: Show percentages based to Total Cases Responding in Categorical Analysis@lilysecret :
Thank you for providing the sample data . However you seem to have added labels on top of the data so - I am finding it a little hard to recreate the report /journal you have.
However, may be if I understand you question , can you try this :
When you launch the tabulate platform , can you drag % of Total and drop it on top of your journal in the column section similar to what I have in the screenshot - I think that might do it .
If you are creating the report through a script - share your code - so I can try walking through it step by step .
Best
Uday
Re: Show percentages based to Total Cases Responding in Categorical AnalysisDone! Edited original post.
@uday_guntupalli wrote:
@lilysecret ,
Please provide sample data to enable the users to help you
Best
uday
Re: Show percentages based to Total Cases Responding in Categorical Analysis@lilysecret ,
Please provide sample data to enable the users to help you
Best
uday
