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

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

iperczak — Wed, 11 Dec 2019 20:02:59 GMT

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.

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

Dan_Obermiller — Wed, 11 Dec 2019 21:18:27 GMT

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.

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

iperczak — Thu, 12 Dec 2019 12:56:24 GMT

Yes, this is done via tabulate

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

Dan_Obermiller — Fri, 13 Dec 2019 16:35:08 GMT

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