Cummalative Data coming incorrect in View Data Mode

[mnvrma]

I have used set analysis "(Sum({<Year={$(vCY)}>}[_Counter_Hours]))" for measure 'Hours' whereas

for measure 'Cumulative Hours' I've used :

"RangeSum(Above( (　(Sum({<Year={$(vCY)}>}[_Counter_Hours]))　) , 0, RowNo()))" .

Data is coming correct in the Combo chart but when I Switch the chart to View Data mode Values for Cumulative coming incorrect. Can Anyone help with it?

[Saurabh_K14999]

Hi, 

I guess the problem is due to Years field in the expression.

try using this expression -

RangeSum(Total((Sum({<Year={$(vCY)}>}[_Counter_Hours])), _Counter_Hours, Count()))

hope this works for you

Regards,

SK

[mnvrma]

I checked that too but not working.