Cumulative Sum

[#1]

This is my graph:

At the moment I am having trouble with the measure "Total Pendente". It´s suppose to sum the number of tickets in state vPendentes of previous months and years.

If in 2014 we close the year with 4 tickets "Pendente" on Jan 2015 it should be: 4 of 2014 plus 1 of Jan 2015.

Another ex: if i select Mar 2016 it should sum all month before Mar 2016 and Mar 2016 included;

It is still important that the graph correspond to selections like client (its on the same table).

Here is the code for Total Pendente at the moment:

RangeSum(

  Above(

    Count(

        {$<status_name = {$(vPendente)},

            Month,

            Year>}

        [ticket_id]),

    0,

    RowNo())

) * Avg(1)

[sunny_talwar · Accepted solution]

May be this:

RangeSum(Above(Count({$<status_id = {1,4,6,7,8,10,12,13,15}, Month, Year, MonthYear = {"$(='<=' & Date(Max(MonthYear), 'MMM-YYYY'))"}>} [ticket_id]), 0,  RowNo())) * Avg(1)

[#3]

Yeah its working!

Thanks a lot