How to sum all records with arcade expressions

[Cesar_AugustoRodriguez]

Hi! I'm working with arcade expressions and I need to summarize all values of all records that I have in a layer to asign a symbology.

Example:

ID	Value
1	100
1	200
2	300
2	400

I need sum (100 + 200 + 300 + 400) = 1000 of the same field, if I'll make a filter over ID = 1 I'll have sum(100 + 200) = 300

When I use the functon Sum() this only sum two o more fields but It doesn't sum all records of the same field

someone could help me with a insights how I can do it

Thank you so much

Regards

[Cesar_AugustoRodriguez]

Thank you Xander Bakker for your help. We solved this doing the summarize in ArcGIS Pro and shared our layer in ArcGIS Online. We applied the symbology with the arcade expressions.

It's very interesting how you use the arcade expressions in your explanation.