Choose Language Hide Translation Bar
Highlighted
Level III

## Show percentages based to Total Cases Responding in Categorical Analysis

Hello, 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Staff

## Re: Show percentages based to Total Cases Responding in Categorical Analysis

Go to the red popup menu by the Categorical title and choose Rate Per Case Responding. I think that will give you what you want.

Dan Obermiller
8 REPLIES 8
Highlighted
Level VIII

@lilysecret ,

Best
uday
Best
Uday
Highlighted
Level III

## Re: Show percentages based to Total Cases Responding in Categorical Analysis

Done! Edited original post.

@uday_guntupalli wrote:
@lilysecret ,

Best
uday

Highlighted
Level VIII

## 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

Best
Uday
Highlighted
Level III

## Re: Show percentages based to Total Cases Responding in Categorical Analysis

Thanks, 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:

Highlighted
Staff

## Re: Show percentages based to Total Cases Responding in Categorical Analysis

Go to the red popup menu by the Categorical title and choose Rate Per Case Responding. I think that will give you what you want.

Dan Obermiller
Highlighted
Level III

## Re: Show percentages based to Total Cases Responding in Categorical Analysis

Thank 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.

Highlighted
Staff

## Re: Show percentages based to Total Cases Responding in Categorical Analysis

That should do the trick as I was using version 13.1 to confirm my thoughts. Upgrading is always a good thing!  :-)

Dan Obermiller
Level III

## Re: Show percentages based to Total Cases Responding in Categorical Analysis

Just wanted to get back to you and say this worked like a charm! Thanks very much!