Non Ordered Running Sum

[#1]

Hey everyone.  I need some help.

I need to sum all of the values in my chart that are larger then the current value.  This is kind of like a running sum, but the values are not in order so i cant do a running sum.  I was trying something like this, but it does work: sum(total aggr(if(sum([New Policy Count])>[New Policy Count], sum([New Policy Count]),0),MainProducer)).

Here is an example of what i am looking for:

ID	NewCount	Desired Result	Calculation
001IL	5	62	5+12+18+27
002IL	12	57	12+18+27
001IN	1	64	1+1+5+12+18+27
002IN	1	64	1+1+5+12+18+27
001OH	27	27	27
002OH	18	45	18+27

[#2]

Hey Micah,

Please check out the attached file. I did the calculation on the back-end and created a field called NewValue which would give you the values you are looking for.

Hope it helps you

Thanks

AJ

[#3]

There are a few ways that i can pre-calculate this, what i am looking for is a way to do it in an expression in my chart.