Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I want to show a cumulative total from month to month for the highest year selected and defaulting to the highest year when no year is selected. I have been able to make a non cumulative line with the code (month by month):
SUM({$< Year={$(=Max(Year))} >}[Customer Incidents])
but am struggling to make a cumulative version (Cumulative YTD).
This is what I have for it now: RANGESUM(ABOVE(TOTAL Sum([Customer Incidents]),0, ROWNO(TOTAL))). Unfortunately it compounds years instead of defaulting to the highest selected. Any help would be appreciated. Thanks!
Try this
RangeSum(Above(TOTAL Sum({$<Year = {$(=Max(Year))}>} [Customer Incidents]), 0, RowNo(TOTAL)))
Try this
RangeSum(Above(TOTAL Sum({$<Year = {$(=Max(Year))}>} [Customer Incidents]), 0, RowNo(TOTAL)))
Or this
RangeSum(Above(Sum({$<Year = {$(=Max(Year))}>} [Customer Incidents]), 0, RowNo()))
This worked. Thanks so much.