This content has been marked as final.
Show 2 replies
-
Re: how to create result with sum above cumulative value of same column?
Sunny Talwar Aug 10, 2017 7:52 AM (in response to chao huang)Would you be able to share a sample where you are trying to do this? or may be share your Excel file with the raw data and the expected output you want to see
-
Re: how to create result with sum above cumulative value of same column?
chao huang Aug 10, 2017 9:01 AM (in response to Sunny Talwar )Hi,
KEY is main dimension
Month is time dimension
logic is:
1.for each KEY, if Month is past month then wanted result is 0
2.for each KEY, if Month is equal or larger than current month, then depending on Balance value (<0 or >=0) to use different calculation way (details in attached file)
most hard part to me is using cumulative value of above rows as a input for next row, in excel it's easy.
regards/HC
-
TB07_20170809_154247.xlsx 12.3 K
-
-