Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In the below screenshot, I have 2 expressions - the blue line is for the selected year ( in this case 2019 is selected) and the red line is for the previous year (selected year - 1). As you can see, in 2019 we have data only until current month, but the accumulation is done for until Dec. How can I show accumulation only until current month if the current year is selected? I have attached a sample QVW for reference.
Thank you.
Hi,
Try this
In Expression for only(Year) give this expression: Rangesum(Above(Sum(Sales),0,Max(Month)))
You can also use these expression if there are no 0 sales for any particular month in the past
Year
=If(Sum(Sales) > 0, Rangesum(Above(Sum(Sales),0,RowNo())))
Previous Year
If(Sum({<Year={$(=Only(Year)-1)}>}Sales) > 0, Rangesum(Above(Sum({<Year={$(=Only(Year)-1)}>}Sales),0,RowNo())))
Hi,
Try this
In Expression for only(Year) give this expression: Rangesum(Above(Sum(Sales),0,Max(Month)))
Try this in the 2018 expression
Rangesum(Above(Sum({<Year={$(=Only(Year)-1)},Month = {$(=Concat(DISTINCT chr(39) & Month & Chr(39),','))}>}Sales),0,RowNo()))
You can also use these expression if there are no 0 sales for any particular month in the past
Year
=If(Sum(Sales) > 0, Rangesum(Above(Sum(Sales),0,RowNo())))
Previous Year
If(Sum({<Year={$(=Only(Year)-1)}>}Sales) > 0, Rangesum(Above(Sum({<Year={$(=Only(Year)-1)}>}Sales),0,RowNo())))