% calculation

[Anya_T]

Hi,

I have data as

Chapter	Count	Country
64	14634	CA
61	12089	EU
62	8022	CA
61	6720	CA
62	5287	EU
64	5084	EU
64	5073	US
39	4743	CA
62	4449	AU
61	3862	CN
61	3849	US
49	3437	AU
85	2912	CA

i want to calculate percentage of each chapter as per country wise and want to display in matrix form?

What should i do?

Expected Result

Chapter	Count	Country	%
64	14634	CA	18.26%
61	12089	EU	15.08%
62	8022	CA	10.01%
61	6720	CA	8.38%
62	5287	EU	6.60%
64	5084	EU	6.34%
64	5073	US	6.33%
39	4743	CA	5.92%
62	4449	AU	5.55%
61	3862	CN	4.82%
61	3849	US	4.80%
49	3437	AU	4.29%
85	2912	CA	3.63%
Total	80161

[TheoC · Accepted solution]

Hi @Anya_T 

You can drag the Chapter field onto your table and then just click the little down arrow to the right.  You can then click on Show Value As, then select Percent of Grand Total / Column Total, etc.

Hope this helps.

Theo 🙂