Cumulative Month Sum in KPI Object

[jyotiwagde]

Hi All,

I have the below table,  New Adv. column contains the data for the advisor who are freshly hired every month.

Cumml column having the running total for each month.

Need to show the total showing at top row on KPI object.

let say we are selecting Dec FY2019 then the KPI should give me the value 69+160+163+199=591

Thanks in advance.

[sunny_talwar]

How about something like this

Aggr(
  RangeSum(
    Above(
      Sum({<[Link Date] = {"<=$(=Max([Link Date]))"}, [Member Type] = {'HM'}, FYear, Month, FQtr>} [Head Count])
    , 0, RowNo())
  )
, Employee, ([Month Start], (NUMERIC)))