Showing only a set of dimension values while using rangesum?

[divya_anand]

Hi,

I have this table where "rangesum" is summing up the current and previous values in "w/o rangesum".

I need to find out if it is possible to see only 2016 data on the dimension, but should have the same values in "rangesum" as is now as shown in the second picture?

FYI: the expression behind rangesum is similar to-

=rangesum(above((Count({<cond1,cond2,cond3>} distinct field)),0,RowNo()))

Does anybody have an idea on this?

[sunny_talwar]

First part of the expression

=RangeSum(Above(Count({<cond1,cond2,cond3, Year>} DISTINCT field), 0, RowNo())) * Avg(1)

Is ignoring Year selection, so any selection you make, all the data is available to view

Second part of the expression

=RangeSum(Above(Count({<cond1,cond2,cond3, Year>} DISTINCT field), 0, RowNo())) * Avg(1)

Is 1 for your selections and 0 for out of selections. So in your example, Avg(1) = 1 for 2016 and Avg(1) = 0 for 2015

For 2016

=RangeSum(Above(Count({<cond1,cond2,cond3, Year>} DISTINCT field), 0, RowNo())) * 1

For 2015

=RangeSum(Above(Count({<cond1,cond2,cond3, Year>} DISTINCT field), 0, RowNo())) * 0

Alternative to using this is to use If statement

If(Count(DISTINCT field) > 0, RangeSum(Above(Count({<cond1,cond2,cond3, Year>} DISTINCT field), 0, RowNo()))

Where again, Count would be 0 for out of selection