cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
iperczak
Level I

Changing the % of Total Tabulate statistic to calculate based on the grouping column

In the plot below, the percentages are being calculated with reference to all of the values in the entire table, but I would like for them to be calculated with respect to the value in each grouping column. In essence, I want all the percentages in each column to add up to 100% for each indiviual column, instead of them adding up to 100% across all 5 of them.

 

Percentage of Total.PNG

3 REPLIES 3

Re: Changing the % of Total Tabulate statistic to calculate based on the grouping column

Did you generate this from the Tabulate platform? If so, there is a Column% option you could use rather than the % of Total. If this is not from Tabulate, where did it come from? That will help us figure out how to get what you need.

Dan Obermiller
iperczak
Level I

Re: Changing the % of Total Tabulate statistic to calculate based on the grouping column

Yes, this is done via tabulate

Re: Changing the % of Total Tabulate statistic to calculate based on the grouping column

Then using the % of Column statistic should work for you.

Dan Obermiller