Nested aggregation: Count divided by Total of the Count column

[Kaushik2020]

Hello everyone,

     Below is a scenario where I am using a Count function to calculate category of an employee for a set of category say Category-1, 2,3 etc.

     Now i have to show Base % of the category in the Output column based on the calculation logic provided in the sheet.

     Here I am not getting the required output for the column. The calculation logic and sample data is attached in the image below. 

expected syntax of the logic: count of employee / Sum of count = base %

Thank you in advance.

[Or]

Count(SomeValue) / Count(Total SomeValue) would be the typical way.