need not to change value

[simonas]

i have formula for calculating :
RangeSum ( Above ( sum( quantity),0,rowno() ) )

i need to make values not change based on date filter.  if i use total or {1} i get wrong values.

[agigliotti]

Hi @simonas ,

You should add date field name in the set analysis as below:

RangeSum ( Above ( sum( {< FieldName= >} quantity ),0,rowno() ) )

Best Regards

[simonas]

wrong

not working RangeSum ( Above ( sum( {< FieldName= >} quantity ),0,rowno() ) ), getting values of current year

good

[simonas]

maybe i use wrong formula, i need to calculate all values always 

[vinieme12]

can you post the exact expression you used?

from the expression posted by @agigliotti 

You just need to replace FieldName with your actual field name that needs to be ignored

RangeSum ( Above ( sum( {< Yourdatefieldname= >} quantity ),0,rowno() ) )

[simonas]

This is original: RangeSum ( Above ( sum(  quantity ),0,rowno() ) ), then i added {<date field>} like @agigliotti  suggested. i did not get result i wanted. 

i need: to calculate all values with condition to add possitve value of previous months. Then i turn on date filter, i lose all possitive values of all month before filter and get only values in range of filter condition.