Nested aggregation: Count divided by Total of the Count column

Kaushik2020 — Sun, 02 Jul 2023 13:21:24 GMT

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.

Re: Nested aggregation: Count divided by Total of the Count column

Or — Sun, 02 Jul 2023 14:44:24 GMT

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