Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to get the data untill selected month in that year only, my report is based on finacial month. Suppose in year 2011
if Apr --1000, may--2000, june---- 3000
reult should be apr---1000, May---3000, june--- 6000, i want write it in expression, not through accumulation.
Hi
use setanalysis expr like
sum({<year=,month={"<=$(=max(month))"}>}amount)
above(sum(amount))
rangesum(above(sun(amount)))
hii
try this in expression
rangesum(above(sum(fieldname),0,rowno()))
This might helps you