% calculation

[#1]

Hi-Can anyone please let me know what can be done to get this % calculation.

State	Count of Call	%
AZ	100	6.7%
CA	300	20%
VA	500	33.3%
TX	600	40%
Total	1500	100%

Count of call is calculated thru a set analysis.
count(DISTINCT {$ < Type={'TEL'} > }call)

I am not sure how can the partial sum which is 1500 in the above example can be achieved?

[#2 · Accepted solution]

count(DISTINCT {$ < Type={'TEL'} > }call)/count(DISTINCT TOTAL{$ < Type={'TEL'} > }call)

¿?

[#3]

Thanks you so much!