Cummulative Sum

[abhijith28]

Can anyone help me out with this

ABC:

Load * inline[

Month, Number
Jan, 1
Feb, 2
Mar, 3
Apr, 4
May, 5
Jun, 6
Jul, 7
Aug, 8
Sep, 9
Oct, 10
Nov, 11
Dec, 12

];

The output should be:

Jan 1

Feb 3

Mar 6

Apr 4

May 9

Jun 15

Jul  7

Aug 15

Sep 24

Oct 10

Nov 21

Dec 33

For every quarter it has to cumulative add, then it has to restart for each quarter. ex:- For Apr -- 4

[sunny_talwar]

Have you tried this?

RangeSum(Before(Sum(Number), 0, ColumnNo()))

[pk]

yes...just tried ... not working in this/my scenario

[sunny_talwar]

What does not working means? Does it show an error message? Does it give you an incorrect output? Did it shut down your computer? Did it kill your electricity?

Not working can mean many things and not knowing what you are getting doesn't really help me help you.

[pk]

it is showing same amount...
not getting calculate cumulative sum of its 

[sunny_talwar]

Would you be able to attach a sample so that I can see the issue?

[pk]

please check...
in the sample data,month no and CF_month are calendar fields, also expected result format is mentioned.

[sunny_talwar]

I was hoping for you to share a sample qvw where I can see the issue. By me building a dashboard on top of the Excel you have shared won't really help... because 1) I will be wasting a lot of my time to build a dashboard on dummy or aggregated data, 2) what might work with this dummy data might not work for your real scenario. I hope you understand my concerns.

Best,
Sunny

[pk]

find files and mentioned output format.

[sunny_talwar]

I used this expression

=RangeSum(Before(Sum([BS Balances]), 0, ColumnNo()))

to get this

[pk]

hello sunny_talwar,

thanks for reply and mentioned formula is working but i want add open bal into april months cumulative  sum and then cumulative sum will get calculate for every months
so i want like -
open bal + GL Balances of April =cumulative sum for April month
(cumulative sum of April+ GL Balances of May)  or (open bal + GL Balances of April + GL Balances of May ) = cumulative sum for May month

(cumulative sum of May+ GL Balances of june)  or (open bal + GL Balances of April + GL Balances of May+GL Balances of june ) =cumulative sum for june month

hope you understand my req.