Cumulative assistance

[JoseGarcia]

Hi there, 

I need to display cumulative values for field 'BTC'.
The cumulative value is for the Finish period (Period must be displayed April-20, May-20 and so on.
using formula:

aggr(rangesum( above( sum(BTC),0,rowno())),[Finish])

I am struggling adding Month and year functions to 'Finish' formula. 
Could anyone assist?

Here is a snapshot of the data file.

thanks a million.

Jose

[MayilVahanan]

Hi @JoseGarcia 

Can you provide the sample file instead of image?

[JoseGarcia]

Hi Mayil, 

here is the file.
Let me know if you need more details.

Jose

[MayilVahanan · Accepted solution]

Hi @JoseGarcia 

Are you looking for cumulation based on Month-Year?

If so, try like below

LOAD Finish,
MonthName(Finish) as MonthYear,
[WBS Name],
BTC,
EVC,
ATC
FROM
[D:\Qlik\Com\Copy of temp1.2.xlsx]
(ooxml, embedded labels, table is Sheet2);

Dim: MonthYear, WBS Name

Exp: rangesum(above(sum(BTC),0,rowno(Total)))

[JoseGarcia]

Mayil, 

you are a genius! it works great! 
Thanks a million for your support.

Jose

[MayilVahanan]

You are welcome