All,
Was hoping someone would be able to help me with a pivot chart issue i am having.
Little background, I'm trying to show the "ultimate" value of the customer after they've received all their deductions to see how much is left. Basically a running total.
| Data |
|---|
| Day | Net Paid | | 0 | 1201 | | 9 | 6000 | | 10 | 5410 | | 11 | -201 | | 12 | 280 | | 13 | -2898 | | 16 | -1000 | | 18 | 710 | | 24 | -3875 | | 25 | 5 | | 26 | -109.25 |
|
The end value of the customer is 5522.75 and i am trying to show this horizontally in a pivot with a cyclical group going vertically.
using the below formula my end result is incorrect at -109.25
=rangesum(above(sum(Claim_Incurred),0,rowno()))
Does anyone have any suggestions?
