Revesre cummulative with difficult logic

[smilingjohn]

Hi All, 

I ahve a very difficult logic to implement in a line chart  . please look into my beow explanantion 

Difficult logic:

I need to show a line chart by month . 

I have month as dimension  and in expression I am using this logic "

Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,rowno()))  

For the above reverse cummulative expression works fine as shown in the figure below . Now i want to add the total count of id's to the max month . how can i achive this .

If i get the total count for the year added to the Oct month then it will cummulate . 

Can any one please help me on this . 

Thanks in Advance 

[smilingjohn]

Hi Community any help on this ?

[smilingjohn]

Hi community

Is my requirements possible ??

[MayilVahanan]

Hi @smilingjohn ,

Try like below

If(MonthYear = Max(Total MonthYear), count({<Status={'Closed'},Dept={'Incometax'}>}Total ID),

Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,rowno()))  )

Hope it helps

[smilingjohn]

Thanks @MayilVahanan  

I tried your expression but this is not working properly ...

[smilingjohn]

Currently this is how my data looks .as shown in the figure . the total ID's are 11 , now this 11 Id's should get added to Sept which should be like 11+4=15 and this 15 should get added to Apr=2+15 and so on till Jan2018 . 

[MayilVahanan · Accepted solution]

HI @smilingjohn 

Try like below

If(MonthYear = Max(Total MonthYear), Rangesum(count({<Status={'Closed'},Dept={'Incometax'}>}Total ID), count({<Status={'Closed'},Dept={'Incometax'}>}ID)),

Rangesum(count({<Status={'Closed'},Dept={'Incometax'}>}Total ID), Count({<MonthYear={'$(=Max(MonthYear))'},Status={'Closed'},Dept={'Incometax'}>}ID))+Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,NoOfRows())) )

[smilingjohn]

@MayilVahanan  

Thanks Your expression works . 

Thanks a lot sir .