Calculating % of a number by category.

Version 3

    Hello Community,

     

    I'm having some issue calculating percentage of one category to the total.

    TypeDateNumber
    A1/1/1010
    B1/1/1012
    C1/2/1112
    A1/3/1113
    B1/1/1216

    For this example, I want to calculate below thing;

     

    % of A = Type A Number/(Type A + B + C numbers)*100

     

    I'm able to do it using table calculation but I want to use formula. Any help is appreciated.

     

    Thanks in advance.