123

[Anonymous]

ABC

[MK_QSL]

Front end or back end?

[MK_QSL]

IF(RowNo() = 1, SUM(TOTAL Sales), SUM(TOTAL Sales)  - RangeSum(Above(SUM(Sales),0,RowNo())))

Small Change..

IF(RowNo() = 1,

  SUM(TOTAL Sales),

  SUM(TOTAL Sales)  - RangeSum(Above(SUM(Sales),1,RowNo()))

)

[MK_QSL]

And if you want the same Value even after selection of Year or Month, use below expression

IF(RowNo() = 1,

  SUM({<Year, Month>}TOTAL Sales),

  SUM({<Year, Month>}TOTAL Sales)  - RangeSum(Above(SUM({<Year, Month>}Sales),1,RowNo()))

) * Avg(1)