rangesum result on a selected year

[ali_hijazi]

Hello got the following graph

my expression is as follows:

RangeSum(Above( total COUNT(DISTINCT{

  1

  <

  Year=$::Year

  ,MonthYear=$::MonthYear

  ,Month=$::Month

  ,QUARTER_YEAR=$::QUARTER_YEAR

  ,Quarter=$::Quarter

  ,FIX_DATE={">=$(vReferenceDate)"}

  ,RECORD_TYPE={'MAINSTREAM'}

  >

  } FIX_ID),1,RowNo()))

how can I keep the cumulative result when I select for example 2011 and still get 74865 on the green line above

Please advise

[sunny_talwar]

Try this:

If(Sum({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month,QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter} FIX_ID) > 0,

RangeSum(Above( total COUNT(DISTINCT{1<Year =, MonthYear = , Month =, QUARTER_YEAR =, Quarter =, FIX_DATE = {">=$(vReferenceDate)"}, RECORD_TYPE={'MAINSTREAM'}>} FIX_ID),1,RowNo())))

[ali_hijazi]

no didn't work

[sunny_talwar]

What about this:

If(Count(DISTINCT {1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month,QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}, FIX_DATE = {">=$(vReferenceDate)"}>} FIX_ID) > 0,

RangeSum(Above( total COUNT(DISTINCT{1<Year =, MonthYear = , Month =, QUARTER_YEAR =, Quarter =, FIX_DATE = {">=$(vReferenceDate)"}, RECORD_TYPE={'MAINSTREAM'}>} FIX_ID),1,RowNo())))