Hello all I'm looking to allocate a number based on the the amount of rows in a specific field
For example:
I get DOG TOTAL:$50
My rows should show
NAME TYPE VALUE
DOG1 DOG $10
DOG2 DOG $10
DOG3 DOG $10
DOG4 DOG $10
DOG5 DOG $10
so for every type dog the total should be spit evenly between all the values even if I add 5 more rows it should recalculate to $5/Name
Thank you in advance
Could you use the summarise tool to calculate average grouped type and then join the results with the starting data set joining type, fewer tools