Average of dynamic percentage

[bharosha]

I need to figure out how to calculate average of the percentage. 

I have a matrix table below. I need average of the percentage of all Categories per Label.

Label	Label 1	Label 2	Label 3	Label 4	Total
Category	IDs	IDs %	IDs	IDs %	IDs	IDs %	IDs	IDs %	IDs	IDs %
A	96	20.1%	134	28.1%	29	6.1%	218	45.7%	477	100.0%
B	62	24.9%	37	14.9%	4	1.6%	146	58.6%	249	100.0%
C	200	21.5%	165	17.7%	48	5.2%	519	55.7%	932	100.0%
D	70	29.9%	26	11.1%	3	1.3%	135	57.7%	234	100.0%
Total	270	17.0%	348	21.9%	75	4.7%	895	56.4%	1588	100.0%
Needed		24.1%		17.9%		3.5%		54.4%		100.0%

[lbendlin]

Your total numbers look off.  Do you have another filter?