Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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?
It seems you need to adjust to the horizontal view with something like:
=rangesum(before(sum(Claim_Incurred),0,columnno()))
- Marcus
Thanks, works a treat.