Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
I checked that too but not working.