Line Chart Curves Changing Between Selections

[MalcolmCICWF]

In my Line Chart, I have a calculation to create a Cumulative % as the months proceed. It works for aStraight Table that I put the code in, but I'm guessing because of the RangeSum or Above functions, it is affecting the chart. Here is the calc being used in my straight table/Line chart and the data...

-If I have one ID selected it shows the smooth curve (ex. 1), then when I select multiple IDs I get dips in the curve (ex. 2) which shouldn't happen in a cumulative setting. I'm trying to get a cumulative of % over the months by each ID, the curve for the line should remain static.... Thoughts?

Ex.1

Ex. 2

[Kushal_Chawda]

@MalcolmCICWF  try below

= sum(aggr(Rangesum(above(total sum({<YourDimension>}PaymentAmount)/sum({<YourDimension>}FaceValue),0, rowno(total))), (YourDimesion,(NUMERIC,ASCENDING))))

[QFabian]

Hi @MalcolmCICWF , did you try using before() instead above()?

[Kushal_Chawda]

@QFabian  Before function is designed to work for pivot table only. 

[MalcolmCICWF]

That one didn't work as soon as there are multiple IDs selected.

[MalcolmCICWF]

ok so let me ask you this... In one expression I am using sum(PaymentAmount)/sum(FaceValue) to get the incremental  % each month. Can I use this expression combine with the Before function in a Line Chart to get a cumulative? All I'm really looking for is to instead of getting incremental each month, get the cumulative as the months go on... so adding in the previous month's % as each month goes on. You can see this in the straight table I provide. 

[MalcolmCICWF · Accepted solution]

I fixed it by using the incremental formula I was using and checking the "Full Accumulation" option under Accumulation in the Expressions tab.