nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Show percentages based to Total Cases Responding in Categorical Analysis

lilysecret

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.

sample.jmp

Accepted answers

Dan_Obermiller

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.

All comments

uday_guntupalli

@lilysecret ,
Please provide sample data to enable the users to help you

Best
uday

lilysecret

Done! Edited original post.

@uday_guntupalli wrote:
@lilysecret ,
Please provide sample data to enable the users to help you

Best
uday

uday_guntupalli

@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

lilysecret

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: