If Statement

[Anonymous]

In the Above table I need for the Breed to be calculated based on the Head Placed column. If the amount of any Breed is more than 80% of the total Head then that Breed will be used in naming, If not then it will be called "MIXED". Any assistance on this will be greatly appreciated.

[#2]

I think using aggr is your solution:

if(sum([head placed]) > sum(aggr(sum([head placed]), [group cd]))*80,'MIXED',[breed])