Not able to calculate Average distribution

[Anonymous]

Hello Community,

I am try to show the distribution of Connections. Below is the example and I need percentage of distribution.

Connection_Type	Distribution	Need This
A	-92	-6%
B	-30	-2%
C	90	6%
D	13	1%
E	-111	-7%
F	494	32%
G	286	18%
H	401	26%
I	500	32%

To calculate the distribution. I am using below set analysis that i can't change.

sum(aggr(SUM(DISTINCT Amount),Emp_id))/ COUNT(DISTINCT Emp_id)  

Thanks in advance.

[Anonymous]

Hello Rahul,

Thanks but to calculate "Average Cost Per Employee". i am using below mentioned logic

sum(aggr(SUM(DISTINCT Amount),Emp_id))/ COUNT(DISTINCT Emp_id)