Cumul inverse

[#1]

Hi all,

I can't figure out how to write the right expression to get a cumul inverse, that is to say a total sum minus cumulated numbers.

In my file, I've got customers who were billed from 0 to n months ("n" is still evolving). Thus there are X customers matching with 0 bill, Y with 1 bill ....Z with N bills .

I'd like to see graphically the following expression:

for month 0 = Total sum

for month 1 = Total sum - customers Month 0

for month 2 = Total sum - (customers Month 0 + customers month 1)

....

for month N = Total sum - (customers Month 0 +.... + customers Month N-1)

Thanks for your help

Julien

[#2 · Accepted solution]

Hi Julien,

I hope I have understood your requirement correctly. You could use the following expression

=TextCount(Total Customer)-rangesum(above(TextCount(Customer),1,rowno()-1))

For convinience, I have attached an example as per my understanding of your data model.

Nimish

[#3]

Hi Nimish,

Thank you for your answer. It works well.

I can go on further with this analysis.

Cheers,

Julien