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
User | Count |
---|---|
17 | |
15 | |
15 | |
8 | |
6 |