Cumulative Sum Help!

[amit_saini]

Hi Folks,

I need to cumulative sum on bar chart , below is my expression:

=num(Money(sum(aggr(sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), CurrencyIsoCode, Month))/1000000),'####')

I'm trying Something like below , but it's not working:

=aggr( rangesum(above( sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), 0, rowno() )), CurrencyIsoCode, Month)

Thanks,

AS

[kaushiknsolanki]

Hi,

Check this.

Rangesum cumulative with 2 dimensions | Qlik Community

If doesnt help share your application.

Regards,

Kaushik Solanki

[amit_saini]

Hi Solanki,

I tried this but it's not working:

=aggr( rangesum(above( sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), 0, rowno() )), CurrencyIsoCode, Month)

Marked in bold are my 2 dim.

Thanks,

As

[Kushal_Chawda]

maybe try

rangesum(aggr(above(total sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), 0, rowno(total)), CurrencyIsoCode, Month))

[amit_saini]

Sorry Kush not working.

Attached is sample.

Thanks,

AS

[Kushal_Chawda]

try this

rangesum(above(total sum(aggr(sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), CurrencyIsoCode, Month))/1000000,1,RowNo(TOTAL)))

[amit_saini]

Sorry not working!

Thanks,

AS

[sunny_talwar]

What is the output you are expecting to see here? You have UP2GO_2F... and Month as your dimensions, but you aggregating on CurrencyIsoCode and Month? Can you provide what the output needs to look like in numerical terms

[amit_saini]

Hi Sunny,

Current :

But Output should be like below Stage values on Bar

Month	Stage
Jan	$51.35
Feb	$53.88
Mar	$132.70
Apr	$200.48
May	$202.90
Jun	$327.13
Jul	$487.90
Aug	$580.32
Sep	$733.42
Oct	$993.76
Nov	$1,014.90
Dec	$1,163.88

Thanks,

AS

[amit_saini]

Sorry This is Current Senario:

And Output in above is comment is required.

Thanks,

AS