Group by one column and sum up the values in other column and find the mean values.

[KRISHNABOMMU]

Hi,

I have a requirement in designer desktop. i would like to know how to group by one column say Staff Title column, then sum up the values in other column say ' Staff Total pay' column and find the mean of the Staff total pay for each title.

Thanks,

Krishna

[Qiu · Accepted solution]

@KRISHNABOMMU 
Most likely you can use a Summarize tool.

But it would be better you can share some sample input and output.

[KRISHNABOMMU]

Thank you!  Yes, i did used the summarize to group by title and averaged the total pay and the results are good. Now i want to display the first 10 Job titles when the averaged total pay is arranged in descending order.

Basically, i need to pick the top 10 job titles that pays the most.

[KRISHNABOMMU]

attached how the input looks like 

[KRISHNABOMMU]

i think i got the desired output using SUmmarize tool. thank you very much!

[Qiu]

For below situation, we can use a Sort tool to Decending order for the payment then use Sample too to pick the first 10 job Titles.

Basically, i need to pick the top 10 job titles that pays the most.

---

---

[KRISHNABOMMU]

Thank you Qiu!